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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Combine sp_attach_db and transaction log restore

Author  Topic  shay-b Starting Member 3 Posts Posted - 2001-04-17 : 06:04:02 Hi I'm trying to create kind of aBackup Server BUT...different approach from the one suggested by Microsoft. The backup server must have the same NAME and IP ADDRESS as the original server when it goe's up. My problem is: I decided to restore the DB by droping the MDF and LDF files from the original server to the backup server and the attachment is really quick. but...I Can't restore any Backup's of Transaction Log files since it's excpecting to have apreceding Restore which contains: WITH NORECOVERY or WITH STANDBY. Is there any TRICK to make it possible to attach aDB (from another server) and than restore Transaction Log files (for changes that took place after droping the MDF and LDF from the original server)??? I'll be very thankfull for any tip or aclue. bye Shay shay