Viewing 9 posts - 1 through 10 (of 10 total)
The conclusion to my problem was that I was doing simple recovery backups anbd and then trying to restore both the MDF and the LDF but with simple recovery ldf's...
February 18, 2005 at 10:33 am
I dropped the device and then ran the headeronly under master db and got the below info.......any thoughts on what could be wrong with the backup?
When i ran the headeronly...
February 18, 2005 at 8:55 am
I ran the restoreheaderonly command and got this
Server: Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'd:\SQLServer\MSSQL\BACKUP\msdb_db_1_200502171829.bak'. Device error or device off-line. See the SQL Server error...
February 18, 2005 at 8:43 am
Now it runs data base reads loading and it just sits....the ldf and mdf are being restored to the proper directory but the DB remains loading.....ANd then I get this...
February 17, 2005 at 12:58 pm
I am in single user and I went in an killed the other running connections now the backup device is off line?
February 17, 2005 at 9:50 am
Now I am getting this
Cannot open backup device 'Full_Bak'. Device error or device off-line. See the SQL Server error log for more details.
???
February 17, 2005 at 9:48 am
Jim,when I try to set single user mode and DBO only I get this messgage
Database options single user and dbo use only cannot be set at the same time.
Any thoughts
February 17, 2005 at 9:18 am
Thank you both for providing me your expertise. I appreciate the help and Jim/Jason......Jim I will post to the open forum in the future thanks....LYNN~~
February 17, 2005 at 9:11 am
Do I need to detach the the db to restore its telling DB in use?
February 17, 2005 at 8:42 am
Viewing 9 posts - 1 through 10 (of 10 total)