Comments
Sort by recent activity
Perfect - thanks / comments
Perfect - thanks
In the SQL Backup GUI... / comments
In the SQL Backup GUI...
Have you tried increasing the connection timeout property for each registered server - right click on the server name and select edit, connection properties tab... That may help? / comments
Have you tried increasing the connection timeout property for each registered server - right click on the server name and select edit, connection properties tab... That may help?
Hi, I had similar problems with my local machine and occasionally a development server disconnecting and showing a timeout error - albeit with SQL2K
It turned out to be because each Server contained several DBs that had the AUTO_CLOSE option set to ON.
With this set ON, each DB is closed after the last user exist it. Everytime the database gets accessed it has to reopen and this can be a slow process.
I am guessing that SQL Backup will effectively try to reopen each database when it refreshes its connection to a server and so it takes a while to start them all up.
This can also cause Enterprise manager to be very slow when you try to expand the Databases node or even the drop down Database combobox in Query analyser seems to go slow if any of the DBs are set to AUTO CLOSE.
Have a look in the SQL Server Logs to see if you are getting many 'Starting up database xxxxx' messages... / comments
Hi, I had similar problems with my local machine and occasionally a development server disconnecting and showing a timeout error - albeit with SQL2K
It turned out to be because each Server containe...