Forum Replies Created

Viewing 9 posts - 1 through 10 (of 10 total)

  • RE: restore bacjup from diff location

    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...

  • RE: restore bacjup from diff location

     

    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...

  • RE: restore bacjup from diff location

    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...

  • RE: restore bacjup from diff location

    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...

  • RE: restore bacjup from diff location

    I am in single user and I went in an killed the other running connections now the backup device is off line?

  • RE: restore bacjup from diff location

    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.

     

    ???

  • RE: restore bacjup from diff location

    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

  • RE: restore bacjup from diff location

    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~~

  • RE: restore bacjup from diff location

    Do I need to detach the the db to restore its telling DB in use?

Viewing 9 posts - 1 through 10 (of 10 total)