Comments
Sort by recent activity
I was having the same problems doing RedGate backups on SQL2005. After I followed Peter's directions, it got corrected. Thank you much! The question I have though if if these SQL commands need to be run every time you reboot the server. I would love to get some information, if possible, on what they mean exactly. Thanks a lot. Pab / comments
I was having the same problems doing RedGate backups on SQL2005. After I followed Peter's directions, it got corrected. Thank you much! The question I have though if if these SQL commands need to b...
Does the last version of Red-Gate supposed to shrink transaction logs after you do a translation log backup? It's not doing it for me. Also, the transaction log, trx, backup is 0 bytes. Could that be right? Could you point me to the syntax for transaction log backup? I imagine I'm doing it wrong since it's 0 bytes. / comments
Does the last version of Red-Gate supposed to shrink transaction logs after you do a translation log backup? It's not doing it for me. Also, the transaction log, trx, backup is 0 bytes. Could that ...
I'm having the same problem. Restarting the server corrects it but only for a time. It seems to come up once a week. If you have any hot fixes for this, please let me know.
thanks / comments
I'm having the same problem. Restarting the server corrects it but only for a time. It seems to come up once a week. If you have any hot fixes for this, please let me know.
thanks
We should be able to backup a DB to a remote server, shouldn't we? I'm really asking...I didn't know if that feature was available in v4.
I am using the same syntax as the person who started this post, but remote backups seem to failed saying...
Backing up master (full database) to:
\\Hawk\D$\RptBackup\Condor4\master_db_(full)_200601250844.sqb
Failed to create backup folder : \\Hawk\D$\RptBackup\Condor4SQL Backup exit code: 500
From the source DB server, I can browse the remote network (through windows explorer) and create folder plus copy files. Also, I can do remote backups with normal SQL syntax right from the Query Analyzer console.
But when I use red-gate v4. remote backups failed. They do work locally...not remotely however.
Any ideas?
Is my syntax wrong...
You mentioned BACKUP DATABASES ... syntax in 4.0. Is there a new script from v3.2? Where may I find that?
Thank you / comments
We should be able to backup a DB to a remote server, shouldn't we? I'm really asking...I didn't know if that feature was available in v4.
I am using the same syntax as the person who started this p...
Just wanted to leave a quick note for those, who like me, just had a hard time finding the SQL backup agent.
When you install Red-Gate v4, it creates a service called SQL Backup agent. It's under windows services. Look it up and make sure that it has access to create and copy files on the remote server.
Thanks / comments
Just wanted to leave a quick note for those, who like me, just had a hard time finding the SQL backup agent.
When you install Red-Gate v4, it creates a service called SQL Backup agent. It's under w...