Red Gate forums :: View topic - Test restore jobs have started failing.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Test restore jobs have started failing.

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
RichardRayJH



Joined: 21 Sep 2009
Posts: 13
Location: Teton Village, WY, USA

PostPosted: Wed Apr 10, 2013 5:37 pm    Post subject: Test restore jobs have started failing. Reply with quote

I've had several scheduled jobs running for months to do a weekly test restore and run DBCC checks on the restored db's. In the last two weeks the jobs have all started failing with this error message:

SQL Backup failed with exit code: 790 SQL error code: 3257 [SQLSTATE 42000] (Error 50000). The step failed.

SQL Backup 7.0.3.2 is installed, I"m updating that to 7.3 right now.

SQL Backup is installed on a Windows Server 2008 VM running on an ESX host (servername = PLUTO). SQL Server 2008 R2 is installed there, also. It manages backups on three SQL servers on the network (srvernames MARS, UTAH and SONORA). Everything is SQL Server 2008 R2. All backups are done locally to their resident servers, then archive copies are copied to three other locations, one off site. The job that were working fine restored the latest backup from four enterprise critical apps (2 on SONORA and 2 on MARS) to the SQL Server instance on PLUTO, the server that hosts SQL Backup. The successful backups then ran the full set of DBCC checks.

The SQL Backup log files I can find are empty, but I don't find them at exactly the path specified in the docco. Where should the logs be on a Windows Server 2008 R2 64-bit machine?
_________________
-
Richard Ray
Jackson Hole Mountain Resort
Teton Village, WY
Back to top
View user's profile Send private message Send e-mail
RichardRayJH



Joined: 21 Sep 2009
Posts: 13
Location: Teton Village, WY, USA

PostPosted: Wed Apr 10, 2013 6:12 pm    Post subject: Reply with quote

Embarassed

I found a log I could look at. It demonstrates that one should always check the easy stuff first. The db's in question have been growing and the destination volume for me test restores didn't have enough room to take the restores anymore.

Pesky Thurman Unit....
_________________
-
Richard Ray
Jackson Hole Mountain Resort
Teton Village, WY
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group