Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from devds on Jul 26 at 10:17 AM 1. Open SQL Server 2005 Management Studio.
2. Connect to the appropriate server.
3. Expand *Databases*.
4. Right-click the desired database, mouseover *Tasks*, mouseover *Restore*
and select *Database*.
5. The Restore Database window will appear.
6. Ensure that the correct database name appears in the *To database*
field. If not, select it from the dropdown.
7. Under *Source for restore*, select the *From device* radio button.
8. Click the button next to the textbox to select the device to restore
from.
9. The Specify Backup window will appear.
10. Click *Add* and locate and select the backup file from the Locate
Backup File Window. Click OK.
11. Under *Select the backup sets to restore*, select all three backups
(full, transaction log, and differential).
12. In the left pane, select *Options*.
13. Under *Recovery state*, ensure that the *Restore with Recovery* radio
button is selected.
14. Click OK to begin restoring the database.
15. Once the restore is complete, a notification box will appear. Click OK
to close the box. You have now restored your database to the most recent
state.
| | | ---------------Original Message---------------
From: David Caddick
Sent: Sunday, July 13, 2014 7:39 PM
Subject: SAP Data Restore With Back Up Taken in Harddisk
Hi,
If the instructions have not helped get your company to hire a SQL Server DBA.
Regards |
| Reply to this email to post your response. __.____._ |   _.____.__ |
