Activity overview
Latest activity by RichardRayJH
Setting up Log Shipping under fire
I've got a production db that has users in it from 6:00 AM to 11:00 PM and runs batch processes from 11:30 PM to 1:00 AM. After that it does maintenance jobs to be RTG at 6:00 AM the next morning.
...
Copy job status codes
When I runexec master..sqbdata 'SELECT * FROM backupfiles_copylist where status <> ''s'' order by lastattempt desc'
one of the columns I get back is 'status'. I'm guessing that:
'S' is 'Suc...
:oops:
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.... / comments
:oops:
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...
Test restore jobs have started failing.
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 mess...
... EXEC master..sqlbackup '-sql "RESTORE DATABASE pubs_copy FROM DISK = [e:\backups\*.sqb] SOURCE = [pubs] LATEST_ALL"'
Perfect. That's exactly what I needed.
Now, let me complicate things a bit. I do a similar thing to restore backups to a test server once a week to run DBCC CHECKDB on them and get another level of certainty as to the goodness of the backups. In that case the .sqb file is on an archive volume located on a NAS in another physical location on a fiber connection. Right now, I manually copy the .sqb to the test server to do the restore as I can't see the archive location for restore purposes; I can't see a way to make it appear 'local' to the restore command.
I could do something tricky with PowerShell to get the file to a location where I could see it, but if there's a better way I'd be happy to hear about it! / comments
...EXEC master..sqlbackup '-sql "RESTORE DATABASE pubs_copy FROM DISK = [e:\backups\*.sqb] SOURCE = [pubs] LATEST_ALL"'
Perfect. That's exactly what I needed.
Now, let me complica...
Restore latest backup to a different database
I have a production database that has a test/training version. The test/training version usually gets updated every night, although users may request that it be left along for up to several days. C...
How to move the console, but not clients
I want to move the SQL Backup console, histories, etc., but leave all server clients unaffected. The new home for the console will NOT have a client on it.
How do I do that?
So if the EXEC statement looks like:
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [RTPOne] TO DISK = ''S:\Backup\RTP-Data\<AUTO>.sqb'' WITH ERASEFILES = 7,
ERASEFILES_REMOTE = 15,
FILEOPTIONS = 4,
MAILTO = ''isadmin@jacksonhole.com'',
DISKRETRYINTERVAL = 30,
DISKRETRYCOUNT = 10,
COMPRESSION = 4,
COPYTO = ''\\n-cali\sqlbackups\RTPSQL\DataFileBackups\RTPONE'',
THREADCOUNT = 15,
VERIFY"', @exitcode OUT, @sqlerrorcode OUT
then all I need is more COPYTO's and the same ERASEFILES REMOTE will apply? / comments
So if the EXEC statement looks like:
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [RTPOne] TO DISK = ''S:\Backup\RTP-Data\<AUTO>.sqb'' WITH ERASEFILES = 7,
ERASEFILES_REMOTE = 15,
FILEOPTIONS =...
Copying to multiple network locations
I currently use Backup Pro to make a local backup and then copy that file to a network share. I would like to copy the file to a couple of other places, also. Is there a way to use Backup Pro to ac...
Move and reallocate licenses
I've got SQL Backup console on one data server and client files on two others. I want to put the console on the same server with our BackupExec interface, move the client tools for instance to a di...