Comments
Sort by recent activity
You did send me an email. Thanks Eddie. / comments
You did send me an email. Thanks Eddie.
I had updated the password for the SQL Server Agent service startup account yesterday, using the Windows Service Manager. It is up and running on both the servers(based on Windows service manager). But on the Red Gate GUI for the destination server, it says "Your SQL Server agent does not appear to be running. Start the SQL SERVER agent?"
I also tried restarting the machines.
Please advise. / comments
I had updated the password for the SQL Server Agent service startup account yesterday, using the Windows Service Manager. It is up and running on both the servers(based on Windows service manager)....
Just to add, I am looking for a failover solution. / comments
Just to add, I am looking for a failover solution.
Thank you! / comments
Thank you!
Thanks Peter! / comments
Thanks Peter!
you are the man! Thanks Peter! Yes it had finished backing up the data. / comments
you are the man! Thanks Peter! Yes it had finished backing up the data.
Hello,
I made the complete backup of one 60 GB database which got compressed to 5 GB using the backup utility of SQLBackup.
then I manually copied the 5 GB "FULL_(local)_DBName_20080301_213332.sqb" file to the remote SQL Server from windows explorer. It took 15 hours to copy the complete 5 GB file because the upload\download bandwidth is 1.5 MB.
I then used the "restore functionality of SQLBackup" to restore "FULL_(local)_dbname_20080301_213332.sqb" file to the remote sql server & it worked great.
Now the real problem
Now that we know that the backup & restore functionality works individually. but when I try to setup logshipping in SQLBackup, Only 22.7 GB(out of 60GB) is processed & then I dont see the job progressing ahead. It just stays there at 22.7 GB. Ideally it should process the whole 60 GB of data.
Please advise how can I find out whats going wrong?
BTW, the logshipping jobs for smaller size databases do work well as intended. Its only this particular database of 60 GB that doesnt work.
your help will be much appreciated.
Thank you! / comments
Hello,
I made the complete backup of one 60 GB database which got compressed to 5 GB using the backup utility of SQLBackup.
then I manually copied the 5 GB "FULL_(local)_DBName_20080301_213332.sqb"...
How can I find the credentials of the SQL Backup Agent service startup user?
Is it the Login information for the server on which sql server is installed?
Do you think restarting SQL Backup Agent service would be useful?
Thanks. / comments
How can I find the credentials of the SQL Backup Agent service startup user?
Is it the Login information for the server on which sql server is installed?
Do you think restarting SQL Backup Agent se...
I used this link, http://msdn2.microsoft.com/en-us/library/aa238208.aspx
and resolved it. / comments
I used this link,http://msdn2.microsoft.com/en-us/library/aa238208.aspx
and resolved it.
Thank you! It worked / comments
Thank you! It worked