October 28, 2010 at 1:18 am
Hallo gents
I've posted the same question in 2000's adminstration forum but it seems that no one is that interested. I am re-posting it here to see if someone can put some thoughts on it.
I've recently moved master db's data and log files to new location and today I had a check at the outcome.
When I use "sp_helpdb master", it returns the new file location while I send a query to master.dbo.sysdatabases, it gives back still the old location.
Is there a way to sync master.dbo.sysdatabases to the new location then?
Thanks!
Bazinga!
October 28, 2010 at 11:43 pm
Did a restart of the SQL Server service help?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 29, 2010 at 2:38 am
Adiga (10/28/2010)
Did a restart of the SQL Server service help?
Thanks for providing this idea, but unfortunately it doesn't work.
Bazinga!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply