Restoring existing database to new server 
Author Message
 Restoring existing database to new server

Hi

whats the best approach to restore a backup made on SQL
server A to SQL server B ( two seperate machines)
the backups are database & transaction dumps, these haev
been copied onto the HDD of machine B and the database
restored, however since the backup there are 20+
transaction logs and it seems that there is no way to
select all 20 logs at once but you have to add each one in
turn

recreation details

right click new created database and alltasks /restore
select from device/ click select devices / click add
change file name from d:\mssql\data to loaction of
transaction logs click on the ... button and select the
transaction log  click ok & ok & then you have to go
through the same procedure to add the next transaction log
etc this seems very time consuming and if you had to
repeat for lots of database would take some time.

has anybody any suggestions, this would not be an issue if
restoring to the same sql server \ machine as you could
select the backup set required but this is not possible on
the new clean server.



Mon, 08 Dec 2003 17:11:26 GMT
 Restoring existing database to new server

Why not quite simply do the restore from query analyzer? It won't take more than a few
minutes to copy&paste the needed restore commands (dust changing FILE number). You get
the info from RESTORE HEADERONLY.

EM2000 has, I think, an option to read contents of a backup file and produce backup
history from there. I'm not 100% and I don't know about EM7 (as I don't use GUI tools
that much).

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com


Quote:
> Hi

> whats the best approach to restore a backup made on SQL
> server A to SQL server B ( two seperate machines)
> the backups are database & transaction dumps, these haev
> been copied onto the HDD of machine B and the database
> restored, however since the backup there are 20+
> transaction logs and it seems that there is no way to
> select all 20 logs at once but you have to add each one in
> turn

> recreation details

> right click new created database and alltasks /restore
> select from device/ click select devices / click add
> change file name from d:\mssql\data to loaction of
> transaction logs click on the ... button and select the
> transaction log  click ok & ok & then you have to go
> through the same procedure to add the next transaction log
> etc this seems very time consuming and if you had to
> repeat for lots of database would take some time.

> has anybody any suggestions, this would not be an issue if
> restoring to the same sql server \ machine as you could
> select the backup set required but this is not possible on
> the new clean server.



Mon, 08 Dec 2003 17:41:49 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. restore to new database to new server

2. How to create a new local Server or Server name on existing SQL Server 2000 installation

3. problems with user- orphans restoring databases into new server

4. Restore a database to a new server.

5. master database restore to new server

6. how to restore database from a bak file to a new instance of SQL Server

7. Replication Error with Restored database on new Server???

8. restore all database to a brand new server

9. Question about moving databases to a new Server with backup restore

10. How to restore database including master, msdb, distributor, to new server

11. Restore Databases to New Server

12. What is the procedure for restoring a backup to a new database on a different server


 
Powered by phpBB® Forum Software