restoring over an existing on SQL 6.5 database 
Author Message
 restoring over an existing on SQL 6.5 database

is it possible to restore over an existing  SQL 6.5  database, I have the
same database and log( name and size) as when it was backup on the new box.
It has been backup by arcserv from a SQl 6.5 box to another 6.5 box , and
get a name pipe 83 error.
but when i recreate the database on the the new box and set it to load it
work fine.
It seems odd that I cant do this. restore on a database that already exist.
I am new to sql 6.5 and have been using 7.0 for a couple months now and i
have no problem with this in 7.0.
can some one tell me what i am doing wrong here.
Thanks DarrenD


Sat, 03 Aug 2002 03:00:00 GMT
 restoring over an existing on SQL 6.5 database

Darren  - yes, it's certainly possible.  Try doing a restore without using
ArcServe - just normal SQL backup

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (412 entries) see

http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.sql-server.co.uk



Sun, 04 Aug 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL 6.5 DB Restoring vs SQL 7.0 DB Restoring

2. Error 3242 Attempting to Restore SQL 6.5 Database to SQL 7.0

3. Please help restore database SQL 6.5 to SQL 2000

4. Please help restore database SQL 6.5 to SQL 2000

5. Please help restore database SQL 6.5 to SQL 2000

6. Restore an SQL 6.5 database on an SQL 2000

7. SQL 6.5 Database Backup and restore to SQL 2000

8. Restore SQL Server 6.5 database to SQL Server 7.0

9. In SQL Server 6.5, how do I recognize an existing database

10. Linking a MS SQL 6.5 Log device to an existing database

11. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

12. Restore 6.5 master database 6.5


 
Powered by phpBB® Forum Software