Activity overview
Latest activity by tstadler
Hello,
Can you verify this license agreement. Because when we purchased our 25 licenses we were told that it was per SQL instance regardless of if on the same server virtual or physical in fact when we installed Red-Gate it needed to be registered on each instance to function. If this is acurate Peter you just freed up 10 of our licenses for other use.
Thank you / comments
Hello,
Can you verify this license agreement. Because when we purchased our 25 licenses we were told that it was per SQL instance regardless of if on the same server virtual or physical in fact whe...
The Log Shipping option within Red-Gate offers some of this. For us, we wrote our own, we generate a backup with a stored proc with the Red-Gate command and then call a stored proc on the destination server telling it it is ready for restore and use the Red-Gate commands to restore. Has more details than that but that is the basics. The Red-Gate Log Shipping works, we just needed a few more items for our environment, so we started with what Red-Gate creates and added the items we needed here. / comments
The Log Shipping option within Red-Gate offers some of this. For us, we wrote our own, we generate a backup with a stored proc with the Red-Gate command and then call a stored proc on the destinati...
We have seen this once using 4.0 on a server we restore transactions logs to hourly. We restarted the SQL server service to resolve it. We then updated to 4.1 and have not seen the problem come back.
Looking at our Red-Gate logs showed a sucessfull restore of a transaction log prior to it stop working.
Deleting database file 'e:\MSSQL\BACKUP\Datacenter_StandBy.bak'.
RESTORE LOG successfully processed 0 pages in 1.336 seconds (0.000 MB/sec).
We are running SQL Server 2000 SP4 on Windows 2003 Server SP1 32Bit / comments
We have seen this once using 4.0 on a server we restore transactions logs to hourly. We restarted the SQL server service to resolve it. We then updated to 4.1 and have not seen the problem come bac...
Cluster feature request
Hello,
Well this weekend we had some major changes on our 2 SQL clusters and now running on the alternate nodes. Here is what we have found, we installed SQL backup on these 2 clusters (Both active...
Syntax question
Well, this will sound a little stupid but I don't usualy handle scripting but I will ask anyway.
I am reworking some scripts that do automated restores here, they pass in a variable to a stored pro...
I really don't want to post my db names here but I can confirm we are past 128 char because the Script that is built for the transaction logs is specifying each db name, exec master..sqlbackup N'-SQL "BACKUP LOGS [1, 3, 3, 4, 5, 6, 7,8,9,10,11,12,13,14] TO DISK = ''G:\SQLBackup\<DATABASE>\<AUTO>'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', ERASEFILES = 2, COMPRESSION = 2, THREADS = 1"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
So I will need to break this down into multiple steps in the job. That will work.
Thanks / comments
I really don't want to post my db names here but I can confirm we are past 128 char because the Script that is built for the transaction logs is specifying each db name, exec master..sqlbackup N'-S...
Well, when using Query Analyser to run the script, I get "Database name length exceeds maximum allowed length : db1,db2,*" (Actual names are longer) The issue is I have 18 Databases and only 14 of them do a transaction backup. Looks like a char length issue with the command in SQL Backup / comments
Well, when using Query Analyser to run the script, I get "Database name length exceeds maximum allowed length : db1,db2,*" (Actual names are longer) The issue is I have 18 Databases and only 14 of ...
Looking through the error codes it points to SQL Syntax error, not sure how this could be I used the GUI to build the scheduled jobs just like my other cluster and other servers. I can email you the script if needed. / comments
Looking through the error codes it points to SQL Syntax error, not sure how this could be I used the GUI to build the scheduled jobs just like my other cluster and other servers. I can email you th...
SQL Backup job failed with exitcode: 850
Hello,
I have setup SQL Backup on a cluster of ours, the full backups are working just fine, but the transation log backups fail with "SQL Backup job failed with exitcode: 850 SQL error code: 0 [S...
That works, Thank you! / comments
That works, Thank you!