Posts
Sort by recent activity
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...
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...
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?
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...
Log shipping set up when transaction logs already exist
The setup wizard for Log Shipping seems to expect that it's the first time tran logs are getting backed up for the source database. If I'm already do 15 minute tran log backups and copying them to ...