Twitter
Google
RSSHow to restore backup onto a fresh system
If you start from a new installed system (os ,db , reinstall), you can restore the database by doing following steps:
1 . Install SQL Server Backup on new system .
2 . Prepare and import backups to new installed SQL Server Backup , a latest full backup and it's later backups required.
3 .Create a restore job to restore your database .
4 . (Optional) . If you want a new database , just enter it in Restore As field .
5 . (Optional ) . If target database has new directory , please "Move ... ..." option , see above image.
**please note that
1 . you need not restore the system database to the new database (master , msdb , temp .etc).
2 . Because SQL Server will create the database by restoring a backup , so you don't have to creat it in Enterprise Manage or Management Studio before the restore.
