Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

small lock appearing on MS SQL 2008 System database files Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2012 2:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 25, 2013 10:00 AM
Points: 1, Visits: 117
I want to migrate MS SQL R2 databases to a new storage on a Clustered environment. There are small locks appearing on Master, Model,MSDB and tempdb data and log files. When i move them out of folder where these currently lives , but when i change path of Master database files in SQL configuration Manager, SQL wont start. Any help in this regard much appreciated.
Post #1376675
Posted Thursday, October 25, 2012 1:51 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 10:03 AM
Points: 1,256, Visits: 1,758
Those little locks just mean that the files have limited access.
for moving system databases follow these steps
http://www.sqlservercentral.com/blogs/basits-sql-server-tips/2012/07/29/how-to-move-master-and-resource-system-databases/


Alex S
Post #1377262
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse