Comments
Sort by recent activity
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
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...
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 ...
What is the best way to determin the MAXTRANSFERSIZE I should be using? Trial and Error? / comments
What is the best way to determin the MAXTRANSFERSIZE I should be using? Trial and Error?
Thanks, this seems to be working great now...
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
Thanks, this seems to be working great now...
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...
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 ...
One issue that I have come across is running the Backup and Log Shipping at the same time...
I ended up just having the log shipping run from midnight till 10 PM then the backup begins at 10 PM (takes roughly 1 hour, but I wanted to make sure it has PLENTY of time to be done before log shipping starts back up...
Also, you can do Native Log Shipping in SQL 2000 Standard... And you can do SQL Backup Log Shipping in Standard as well... / comments
One issue that I have come across is running the Backup and Log Shipping at the same time...
I ended up just having the log shipping run from midnight till 10 PM then the backup begins at 10 PM (ta...
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...
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...