Post reply

Restore with Move Fails

  • October 28, 2002 at 9:44 pm

    #105291

    Anyone with with a solution, please help...

    Server: Msg 913, Level 16, State 8, Line 15

    Could not find database ID 65535. Database may not be activated yet or may be in transition.

  • October 30, 2002 at 5:21 pm

    #439856

    Also, are you restoring over an existing db or a new db?

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • October 31, 2002 at 3:19 pm

    #439997

    Wich SQL version? Please post more info.

  • October 31, 2002 at 7:30 pm

    #440015

    Solart! The T-SQL is ....

    RESTORE DATABASE ScalaBackup FROM DISK='F:\mssqldata\MSSQL\BACKUP\ScalaDB_backup'

    WITH

    MOVE 'SCADEV1' TO 'F:\mssqldata\MSSQL\Data\ScalaDB_Backup.mdf',

    MOVE 'SCALOG' TO 'F:\mssqldata\MSSQL\Data\ScalaDB_Backup_log.ldf'

    Hi Steve, I am restoring to a new DB with the move option.

    Racosta! I am using SQL Server 2000

  • March 27, 2003 at 7:48 am

    #452335

    Did you see any errors in your SQL Server errorlog? There is an explanation in BOL for error 913 but it seems not relevant to database restoration directly.

    Cash,

    Try DBCC SHRINKFILE with option 'Emptyfile'. See BOL for details.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply