FOD
22-03-2007, 12:36 PM
Really nice Carl, Exactly what I wanted.
Restoring to a different server is a little more complicated than usual -
the following may help:
http://support.microsoft.com/kb/314546/en-us
For SQL Server 2005, Select the existing database, Select Tasks > Restore with the right mouse button, locate and select the backup file.
Lastly in the left pane select OPTIONS and select 'overwrite the existing database'
Regards,
David.
Restoring to a different server is a little more complicated than usual -
the following may help:
http://support.microsoft.com/kb/314546/en-us
For SQL Server 2005, Select the existing database, Select Tasks > Restore with the right mouse button, locate and select the backup file.
Lastly in the left pane select OPTIONS and select 'overwrite the existing database'
Regards,
David.