Activity overview
Latest activity by Jeff Randall
I am also getting the same error when I try ot backup a DB from this server.
Login failed for user 'jrandall'. Server : SOY SQL authentication User name : jrandall / comments
I am also getting the same error when I try ot backup a DB from this server.
Login failed for user 'jrandall'. Server : SOY SQL authentication User name : jrandall
Odd permissions issue with restore
Running the following:
master..sqlbackup N'-SQL "RESTORE DATABASE [ic001CommonPrd]
FROM DISK = ''D:\SQLBackups\FULL_PILS_ic001CommonPrd_20061206_020022.sqb''
WITH STANDBY = ''C:\Program Files\Micr...
Log Shipping process running indefinatly
DBCC xp_sqlbackup(FREE)
Go
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-sql "RESTORE LOG [SOY_usc001prd] FROM DISK = ''\\Server\d$\SQLBackups\SOY_usc001prd_*.sqb'' WI...
Yes this is the reason for not wanting to upgrade right now...
I will try this during the next maintenance window (Sunday), but do you have any ideas in the meantime?
It seems ot be working just fine one one of the DBs (very small DB and small number of transaction) but is currently failing on the larger db (with vastly more transaction)...
I am currently reseading the large DB and going to try to it again to see if I can get it up and running again, but if this doesn't work, I don't want to go another 72 hours without log shipping. / comments
Yes this is the reason for not wanting to upgrade right now...
I will try this during the next maintenance window (Sunday), but do you have any ideas in the meantime?
It seems ot be working just fi...
4.1.0.207 Restroing Logs created in 4.2.511
I have tested this new version 4.2.511 importing log files created from an older version (4.1.0.207). This seems to be working just fine in production.
I have also been able to import into an older...
Currently the server running 4.1.0.207 successfully restores the log files sometimes.
For instance last night it ran just fine from 3:30 PM - 10: PM
At 10: PM I have Log Shipping stop so I can run the nightly backups.
At midnight when log shipping was supposed ot kick back in the restore began hanging.
It doesn't fail, but it does not process any records, and it was running for over 7 hours before I canceled the job... / comments
Currently the server running 4.1.0.207 successfully restores the log files sometimes.
For instance last night it ran just fine from 3:30 PM - 10: PM
At 10: PM I have Log Shipping stop so I can run ...
Jeff Randall wrote:
One other question...
I have tested this new version 4.2.511 importing log files created from an older version (4.1.0.207).
Can an older version (4.1.0.207) import log files generated by 4.2.511? This does not seem to be working for me currently, however I have not delved into it too deaply yet to figure out if that is the problem, or if there is another issue...
/ comments
Jeff Randall wrote:
One other question...
I have tested this new version 4.2.511 importing log files created from an older version (4.1.0.207).
Can an older version (4.1.0.207) import log files ...
By "Monitoring" I essenatilly mean one place to go to see all the servers (the SQL Backup front end where I have added all 10 of the servers I have SQL Backup installed).
I can view fairly quickly which servers are not creating their logs, restoring logs, or doing their nightly backups.
As Brain said, to stop/start/pause, oyu have ot go to each server individually and stop the SQL Job.... / comments
By "Monitoring" I essenatilly mean one place to go to see all the servers (the SQL Backup front end where I have added all 10 of the servers I have SQL Backup installed).
I can view fairly quickly ...
For anything that you need SQL DataCompare, you'd have to import the table(s) with the data, which will take longer, but would allow you to continue to use SQL Data Compare... / comments
For anything that you need SQL DataCompare, you'd have to import the table(s) with the data, which will take longer, but would allow you to continue to use SQL Data Compare...
SQL Backup creates smaller files.
In my setup, we have the Prod DBs in VA, and the DR site in GA. We are restoring the logs on the other side of a VPN tunnel, so size/bandwith/speed is an issue.
SQL Backup can also allow you to encrypt the files (I'm not using this feature, since the VPN tunnel handles encryption for me) so if your files ever need to be in the open, you can be sure your data is secure.
And, I know it's not really a reason to use one over the other but, as the DBA dealing with it on a daily basis, I like the interface for SQL Backup, where I can easily see at a glance how log shipping is doing across all servers.
The one negative I've come across for SQL Backup have been memory issues. I just installed the new 4.2.511 build, and it seems to be better, but this had been a major sore spot for the last 4-6 months... / comments
SQL Backup creates smaller files.
In my setup, we have the Prod DBs in VA, and the DR site in GA. We are restoring the logs on the other side of a VPN tunnel, so size/bandwith/speed is an issue.
SQ...