Changing Default location of Databases (MDF, LDF) and Backup in SQL Server 2012

Log on your server by passing the credential. And open the property page as following.

Right click on server and select the Properties from options

p1

 

And change the Location of  MDF, LDF or /and Backup

P2

 

Press ok , it may need restart of SQL Server.

 

Leave a comment

Microsoft SQL Server, Error: 5120 (Access Denied)

Problem:
I am trying to attach a database into MS SQL server 2012/ Altering from Read only true to Read only fals;
The following error is occurred:
Unable to open the physical file “, filename”, Operating system error 5: “(Access Denied)”. (Microsoft SQL Server, Error: 5120)

Err5120

Cause:
The associated file/s (.mdf or .ldf) read only or SQL (user) do not have permission to access file in the location it saved.
Solution:
Browse the location of file/s (.mdf or .ldf) right click on file –>Properties

E2

Click On security Tab –> Select the user (for me it is Everyone) –>click on Edit
And check the full control/ Modify option in Allow column–> Apply –>OK
Do the same for all other associated files, if any.
Now it’s completed. Try what are you doing.

Leave a comment

My Blog’s status 2013, thanks to all visitors

My Blog's status 2013, thanks to all visitors

Hi
I am very glad to see the growth of my blog, I am posting this after so many days as a new post , and I am very thak full for all the visiters and commenters. I got Aprox 15000 visiters til date, this a big achivements for a blogger.

Leave a comment

SQL server database Mirroring Error

One time when I am dealing with Mirroring with SQL server 2008 database, on my students stand alone desktop we encounter the Error:
The server network address “TCP://SQLServer:5022″ cannot be reached or does not exist.
Check the network address name and that the ports for the local and remote endpoints are operational.
(Microsoft SQL Server, Error: 1418)
We tried very hard but unable to short out the Error.
One day I get one mail from SQLAuthority.com as I’m a subscriber of mail. In that mail I got the solution. The link is as:
http://blog.sqlauthority.com/2010/03/18/sql-server-mirroring-configured-without-domain-the-server-network-address-tcpsqlservername5023-can-not-be-reached-or-does-not-exist/#comment-201918
And my recommendation for readers, please see this also.
http://blog.sqlauthority.com/2010/01/11/the-server-network-address-tcpsqlserver5023-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-that-the-ports-for-the-local-and-remote-endpoints-are-operational-microso/

Leave a comment

Finding out how much memory SQL Server is utilizing?

Many time for a new DBA  hard to find how much My Server utilising memory? Here is explained a number of ways to find the memory utilized by SQL server.

By Using Performance monitor:

 Go to Start–>Run and type perfmon . You will find the following screen where you can see the total memory used(the pages/sec) by your box.

By Using DMV:
You can Query to sys.dm_os_memory_clerks DMV to find out Memory utilization by SQL server. To see how see the following link.

http://www.sqlservercentral.com/Forums/Topic1188221-391-1.aspx

By using SQL Reports:

Right Click on SQL Server–>reports–>Standard Reports–> Memory Consumption

See the Following image.

Leave a comment

My blog is growing…

Today is 24 sep. my blog’s foundation day, This article is written in response of my blog’s foundation day, on 24th September 2010 I was started this blog, which is dedicated to Beginner SQL DBA and other who are interested to know about. As on 15 September 2011 I have 1,824 visitors.

My blog is growing…

I am very glad, by seeing the growth of my technical blog http://mumbaisqldba.wordpress.com/ and I am very thank full of my visitors and comment writers.

References Coming from:

Most references are coming from Google and others…

Leave a comment

Microsoft certification path on SQL server:

Technology Specialist (TS):

Microsoft provide MCTS certificate after passing any one Exam of 70-432 for DBA or 70-433 for developer and 70-448 For BI. Here I am giving a rot map which is broadcasted by Microsoft itself on their website. To download the PDF Click here.

More: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab2

IT Professional certification (Pro):

Exam 70-450 : Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008.

Exam 70-451 : Designing Database Solutions and Data Access Using Microsoft SQL Server 2008.

Exam 70-452 : Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

Visit for more: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab3

Advance:

MCM:

Exam 88-970: SQL Server 2008 Microsoft Certified Master: Knowledge Exam. And

Exam 88-971: SQL Server 2008 Microsoft Certified Master: Lab Exam

More: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab5

MCA:

Successfully pass the MCA Board Exam conducted by Microsoft and industry experts.

More: http://www.microsoft.com/learning/en/us/certification/architect.aspx

Leave a comment

Follow

Get every new post delivered to your Inbox.