Moving a database with Microsoft SQL Server Management Studio will show you both methods and allow you to choose the one you prefer. It is simple and easy and avoids clicking the mouse all over the screen. You have two options you could use to carry out this task: This blog entry is also available as a TechRepublic gallery and as a TechRepublic download.Īs a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc.
0 Comments
Leave a Reply. |