![]() ![]() For example, the current structure is the following: Simply type a new path to the database and log file ( Figure G). It is the same as the move option that will be discussed later in this tutorial. This is where you specify a new path for your database files. You are now at the critical point of the restore where you choose Options from Select a Page. Place a check in the checkbox to continue as shown in Figure F. Your file now appears in the Select backups to restore text box. Figure D To Database Figure E From Device The Restore Database window appears and we will begin by typing the name of the Database we want to restore in the To Database field ( Figure D) and choosing the From Device radio button to choose where your backup file is, shown in Figure E. Now that you have the Management Studio opened, right-click on Databases and choose Restore Database ( Figure C). We will continue the tutorial from this point. Note: I am going to assume that you already know how to backup a SQL Server database and that you have placed the backups on a file server or copied the backups to the new server. Figure A Search field Figure B SQL Server Management Studio ![]() We will begin by opening SQL Server Management Studio from the Start Menu by choosing Start and typing SQL Server in the Instant Search field ( Figure A) The SQL Server Management Studio appears ( Figure B) and it will be the main area you use to restore your backups. Moving a database with Microsoft SQL Server Management Studio This How do I… 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. You have two options you could use to carry out this task. As 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. This blog entry is also available as a TechRepublic gallery and as a TechRepublic download. How Do I… Restore a SQL Server database to a new server? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |