Posts
Sort by recent activity
Log Backups with CopyTO
Hello
I have an instance of SQL 2014 that I am running log backups every 15 minutes and using the copyto command to copy to a second server for DR.
The issue is that if I use the queued copy, I fin...
Help Cleaning up Large Reg Gate Files
Hello
I have two very large files, that appear to be some Red Gate files. Can you please advise on how I can clean these up? Are they needed? Maybe they need to be moved? What roles do they pla...
Upgrade from Version 3 to 4
I recently upgraded a server from Version 3 to 4.
I can not activate my new license for version 4. adn the GUI Still shows it as version 3.
Anyone ever see this?
Thanks
Q
Backup Jobs Hanging
Has anyone ever encountered an issue where the backup job just hangs?
The only way i have found to fix this is to restart the SQL Backup Service.
Some Background:
I have this installed on many diff...
exitcodes
Does anyone know where i can get a list of exitcodes and what they mean?
Any help is greatly appreciated.
Thanks,
Q
Backup Question
When i run the script below in Query Analyzer, it returns the results.
If i run the script below in a Job, is there anyway to record to output? Does it already write teh resutls to a table?
master...
Backups Failing
Last night the server ran out of space. THe backup Job was hung.
So i killed the process.
Now, i cleared up plenty of disk space. THe job errors out.
Here is the error.
Access violation at addres...
Verifing Backups
If i read the spec sheets right, i noticed that the Verify only works if you use the GUI. Is that true?
If so, is there any way to verify the backup?
Thanks
Q
Failing Job
I write a script to backup my DBs using redgate. I than create a SQL Job that runs my script.
I set it to send me an email upon completion. I also monitor the Job, and receive alerts when the Job...
Encrypted Password
Is there a command that will encrypt the password?
I wnat to pass a passsword and get the encrypted version of it.
I know i can do it throught hte wizard, i just was curious if there was a way to d...