Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ecosoft
Starting Member
2 Posts |
 Posted - 2011-11-02 : 03:13:56
|
| SQLSERVER 2008Has been installed on a new server because the old server( with 2005)The mdf files of the user database were recovered but nothing else so thee were attached to new 2008. BUT there are a pile of backup files on an external disk and tape from the 2005 installation which not longer existsHow can I register these old backup files in the media sets and backup sets on the new server so they are available for restoreNote they are only restored to temporary development databases such that comparisons can be made of the differences between backups and data volumes |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-11-02 : 05:42:23
|
| You don;t need to register the files in order to restore them (although if they are "known" to the MSDB database then users can use the GUI tools to restore from them).You can just use a RESTORE command to restore any (suitable) backup file. |
 |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-02 : 10:33:01
|
| Yes. When you restore the backup taken in 2005, it'll be upgraded to 2008 version.restore database <yourdb> from disk='full path of backup' |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-11-02 : 10:56:55
|
| "restore database <yourdb> from disk='full path of backup'"If your paths are not identical to the original server the RESTORE command will need a bit more than that ...Restore command syntax examples:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300Tasks after restoring a SQL 2000 / SQL 2005 database to SQL 2008:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 |
|
|
|
ecosoft
Starting Member
2 Posts |
Posted - 2011-11-04 : 01:13:40
|
| Thanks for all your input BUT the ability to restore them is not the issue . They need to be "known" to msdb for for a number of procedures we use (as mentioned by Kristen). For example the user needs to determine the status of an item on a particular day and so on entering the date the routine will scan the msdb for the relevant backup and log files and then issue a restore command to a temporary database the the user can see. so I really need all those old backups to be in the msdb!! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-11-04 : 13:46:38
|
| Probably too late now, but you could have upgraded your SQL 2005 database (i.e. including all system databases) to SQL 2008. That would have preserved all the MSDB data.Beware that MSDB data is purged, so it may not remain a long enough history for your purposes. |
|
|
|
|
|
|
Can I Reinstating backups/mediasets from disk