How to restore Database in sql server
In this article I have explained about how to Restore Database using SQL Server.
Each steps I have clearly explained in this article.
How to Restore Database using SQL Server
In this article I have explained about how to Restore Database using SQL Server.
Each steps I have clearly explained in this article
Step 1: Open SQL Server management Studio
Step 2:Connect to the appropriate Server and right click databases.
Step 3:Select Restore Database then click it (see below image).
Step 4:Restore Database Window will display (See below image).
Step 5:Give Restore Database name (see below image).
Step 6:Select from database or from the device (Here I''m selecting from Device).
Step 7:Click the button nearest from the device. (see below image)
Step 8:Specify Backup window will display (see below image)
Step 9:Click add button and you will get Locate Backup file-Servername window.
Step 10: select your bak files.
Step 11: then click the ok button.
Step 12:Your path will display in Specify Backup window.If an unwanted path is displayed then remove it.
Step 13: if does not have more then one path then click the ok button.
Step 14:The database backup file path will display in Restore database window (see below image)
Step 15: select latest Restore database file.
Step 16: finally click ok button
Step 17: if your database is already in the server then click the options button Click the overwrite the existing database (With Replace) checkbox.
i have one QA
if i have 10.0.1600 version of sql server 2008, but my client have sql server R2 version no 10.50.2500 . if i get database backup from my client machine, but I couldnt restore in my local machine.
i know the version is conflicts the sql back up.