Competition: What’s your favorite Redgate tool? Enter now.

Restore DB Failure

thomascroththomascroth Posts: 17
edited December 20, 2006 11:02PM in SQL Backup Previous Versions
Running SQL Backup v 4.6.0.815
SQL Server 2000 Enterprise Edition SP4
Windows 2003 Server Enterprise Edition SP1

I use SQL Backup to backup all of my databases. The databases are backed up to a network share. This process works fine, without any problems. I get an error when trying to restore a database. I have even put a copy of the backup file on the local server to eliminate network issues. I have plenty of memory and disk space available. I still get the exact same error.

The SQL Backup service uses the same domain 'sa' account as SQL Server and SQL Server Agent.

When trying to restore, I get the following error:

SQL Backup log file
12/20/2006 4:00:55 PM: Reading filelist of "D:\sqlbak\FULL_SERVERPL_mydb_20061220_121549.sqb"

12/20/2006 4:00:55 PM: RESTORE FILELISTONLY FROM DISK = 'D:\sqlbak\FULL_SERVERPL_mydb_20061220_121549.sqb'

12/20/2006 4:00:56 PM: Logical name : mydb
Type : D (Data file)
Physical name : D:\sqldata\mydb.mdf
Size : 4.000 MB

Logical name : mydb_log
Type : L (Log file)
Physical name : D:\sqldata\mydb.ldf
Size : 1.000 MB

SQL Backup log file
12/20/2006 4:01:12 PM: Restoring mydb (database) from:
D:\sqlbak\FULL_SERVERPL_mydb_20061220_121549.sqb

12/20/2006 4:01:12 PM: RESTORE DATABASE [mydb] FROM DISK = 'D:\sqlbak\FULL_SERVERPL_mydb_20061220_121549.sqb' WITH NORECOVERY

12/20/2006 4:01:12 PM: Error 890: RESTORE DATABASE permission denied for database: (mydb)
12/20/2006 4:01:12 PM: SQL error 945: Database 'mydb' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.


I see nothing in the SQL Server log files or the Windows Event Viewer. Any assistance would greatly be appreciated.

Thanks!!!
Tom

Comments

  • peteypetey Posts: 2,358 New member
    Could you pls convert the sqb file to a native SQL Server backup file, and try restoring that file? E..g

    sqlbackup '-sql "CONVERT ''D:\sqlbak\FULL_SERVERPL_mydb_20061220_121549.sqb'' TO ''D:\sqlbak\FULL_SERVERPL_mydb_20061220_121549.bak'' " '
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.