-
Restoring
Hi All,
I'm trying to restore a database to a completely new database from an exsiting full backup.
On the backup device there are two full backups from different dates.
How can I specify which one of the two backups I want use for my restore (The only difference is the date ??
Thanks,
-
when you rin this command you can find what position the filegroup is .
restore headeronly from disk = 'd:\mssql70\backup\xxx'
then run restore command by passinf FILE=filenumber parameter.
restore database xxx123 from disk = 'd:\mssql70\backup\xxx' with FILE=6 ,
move 'northwind' to 'd:\xxx123.mdf',
move 'northwind_log' to 'd:\xxx123.ldf'
-
Question
Thanks for the reply MAK.
Just a quick question on the restore process.
1. Why is it neccessary to move the data and log files. Won't these be created new ?
2. Will moving these affect the original database from which the backup was based on ?
Thanks again,
hillchaser
Melbourne/Aust/12:38 pm
-
if you are restoring the same database then no need to move. but if you are restoring the backup as a new database then you need to specify different databasename and mdf and ldf location.
here i am restoring Northwind database as xxx123 database. so i have to specify new .mdf and .ldf names and location.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|