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
And change the Location of MDF, LDF or /and Backup
Press ok , it may need restart of SQL Server.
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)
The associated file/s (.mdf or .ldf) read only or SQL (user) do not have permission to access file in the location it saved.
Browse the location of file/s (.mdf or .ldf) right click on file –>Properties
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.
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.
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:
And my recommendation for readers, please see this also.
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.
By using SQL Reports:
Right Click on SQL Server–>reports–>Standard Reports–> Memory Consumption
See the Following image.
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…
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.
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
Exam 88-970: SQL Server 2008 Microsoft Certified Master: Knowledge Exam. And
Exam 88-971: SQL Server 2008 Microsoft Certified Master: Lab Exam
Successfully pass the MCA Board Exam conducted by Microsoft and industry experts.