Sql Server: Move System Databases

Posted by Sqltimes
On April 12, 2011
0 Comments

In the previous post we noted how simple it is to move user databases. Now we’ll look at moving System database. Moving system databases is as simple as moving user databases (with a couple of extra steps). But if done incorrectly, could leave the Sql Server instance in a unstable and unresponsive state. So I […]

Posted by Sqltimes
On April 8, 2011
0 Comments

There are several ways to move ‘User’ database file location. Attach/Detach Backup/Restore ALTER DATABASE MODIFY FILE 1 (Attach/Detach) and 2 (Backup/Restore) are straight forward and are more popular that the 3rd option, which is what I cover in this post (Please note that there are other ways to do this too). Following script allows to […]

Sql Server: Move System Databases

Sql Server: Move User databases