How can we help you today? How can we help you today?
JoshDBGuy
Activity overview Badges (0) Posts (5) Comments (6)

Activity overview

Latest activity by JoshDBGuy

Splitting Up Backup and Copy Functions
  1. Community
  2. SQL Backup Previous Versions
Is there a way to split up the backup and copy functions using Redgate? I can do backups myself and then use SQL/Powershell to do copies to network locations but I'd rather use redgate. Is this pos...
2 followers 3 comments 0 votes
That's perfect, thank you so much. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Multiple Network Shares
That's perfect, thank you so much.
0 votes
Multiple Network Shares
  1. Community
  2. SQL Backup Previous Versions
Hi All, I'm sure this has been asked before but I'm unable to find it. I would like to add multiple network shares to the "Copy To" option but I am unsure of the syntax. Can someone help me out? Th...
2 followers 2 comments 0 votes
All, I figured it out. Thanks / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Transaction Log Backups Failing
All, I figured it out. Thanks
0 votes
Transaction Log Backups Failing
  1. Community
  2. SQL Backup Previous Versions
Hello, This morning I started running into T-Log backup issues. Here is the information, 1. T-Log backups were working fine until 5:00 AM this morning. 2. At that time I started receiving errors wi...
2 followers 2 comments 0 votes
Thanks epetro, I thought of something like that too. It's not super clean but it should work for our office. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Redgate Backup - Won't Delete All Files Before Backing Up
Thanks epetro, I thought of something like that too. It's not super clean but it should work for our office.
0 votes
Sure, below is the code, DECLARE @exitcode int DECLARE @sqlerrorcode int EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [DB1,DB2,DB3] TO DISK = ''C:\Backup\Full\<database>\<AUTO>.sqb'' WITH ERASEFILES_ATSTART = 1b, PASSWORD = ''<ENCRYPTEDPASSWORD>xxxxxxxxxxx</ENCRYPTEDPASSWORD>'', CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, KEYSIZE = 256, THREADCOUNT = 23"', @exitcode OUT, @sqlerrorcode OUT IF (@exitcode >= 500) OR (@sqlerrorcode <> 0) BEGIN RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode) END I also double checked and no tape backups are running or did run at the same time. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Redgate Backup - Won't Delete All Files Before Backing Up
Sure, below is the code, DECLARE @exitcode int DECLARE @sqlerrorcode int EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [DB1,DB2,DB3] TO DISK = ''C:\Backup\Full\<database>\<AUTO>.sqb'' WITH ERAS...
0 votes
Redgate Backup - Won't Delete All Files Before Backing Up
  1. Community
  2. SQL Backup Previous Versions
I am running backups to a location with limited storage. Because these backups aren't exactly critical, I only need one backup file. I am setting the program to run and delete existing backup files...
2 followers 4 comments 0 votes
I'm guessing I might just have to accept this as a possible issue with restores? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Failed Restore - Failed to disconnect existing connections
I'm guessing I might just have to accept this as a possible issue with restores?
0 votes
I took care of that issue but maybe you can look at this one? Another failure, different DB (failed after 20 seconds), this restore does have kill connections enabled and it looks like this was set up with another script that runs prior to the restore that also kills connections, ERRORS AND WARNINGS 1/5/2013 10:00:01 PM: Restoring XXXX_XXXX (database) from: 1/5/2013 10:00:01 PM: \\XXXX\XXXX.sqb 1/5/2013 10:00:05 PM: ALTER DATABASE [XXXX] SET ONLINE RESTORE DATABASE [XXXX] FROM VIRTUAL_DEVICE = 'SQLBACKUP_XXXXX', VIRTUAL_DEVICE = 'SQLBACKUP_XXXXX', VIRTUAL_DEVICE = 'SQLBACKUP_XXXXX', VIRTUAL_DEVICE = 'SQLBACKUP_XXXXX', VIRTUAL_DEVICE = 'SQLBACKUP_XXXXX', VIRTUAL_DEVICE = 'SQLBACKUP_XXXXX', VIRTUAL_DEVICE = 'SQLBACKUP_XXXXX' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'XXXXX' TO 'D:\XXXXX\XXXXX', MOVE 'XXXXX_log' TO 'D:\XXXXX_log', REPLACE 1/5/2013 10:00:38 PM: Thread 0 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 1/5/2013 10:00:38 PM: 1/5/2013 10:00:38 PM: Thread 1 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 1/5/2013 10:00:38 PM: 1/5/2013 10:00:38 PM: Thread 2 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 1/5/2013 10:00:38 PM: 1/5/2013 10:00:38 PM: Thread 3 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 1/5/2013 10:00:38 PM: 1/5/2013 10:00:38 PM: Thread 4 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 1/5/2013 10:00:38 PM: 1/5/2013 10:00:38 PM: Thread 5 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 1/5/2013 10:00:38 PM: 1/5/2013 10:00:38 PM: Thread 6 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 1/5/2013 10:00:38 PM: 1/5/2013 10:00:39 PM: SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally. 1/5/2013 10:00:39 PM: SQL error 3101: SQL error 3101: Exclusive access could not be obtained because the database is in use. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Failed Restore - Failed to disconnect existing connections
I took care of that issue but maybe you can look at this one? Another failure, different DB (failed after 20 seconds), this restore does have kill connections enabled and it looks like this was set...
0 votes
Total activity
15
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
4