I think I have done something incredibly stupid.
We are taking backups of a clients Production system (SQL 2000 database). We will use it for testing / development.
I restored the database successfully on our server. I then noticed that the log files were huge, so decided to detach the db, delete the log file, and re-attach, to obtain a smaller log file.
I have done this many times, and thought it would be seamless.
Unfortunatley there were 2 log files. I deleted both of them.
Now I cannot attach the db. I have deleted the backup, as I had the db setup on our server.
I cannot attach the db as i get the following errors...
Device activation error. The physical file name 'H:\data\ARV_log.ldf' may be incorrect.
Device activation error. The physical file name 'H:\data\ARV_log_1.ldf' may be incorrect.
I have found comments on the web stating that this is expected behaviour when more than 1 log file existed ?
Is there any way to attach the db, and create 2 empty log files. I have tried creating a new db, with both log files, and using those (Same DB name) , but SQL sees them as files for a different db..
Any idea's ?
It is a mission to obtain a new copy of the backup, as the client needs to courier the backup on hard disk, as it is large.