View Single Post
Old 03-13-2012, 10:17 AM
James Dawes James Dawes is offline
UltraBac Technical Support Manager
Join Date: Mar 2007
Posts: 129
Default SQL Agent F.A.Q.s

Some things to remember when backing up Microsoft SQL databases

UltraBac 9.2x currently supports the following versions of SQL:
SQL 2000 (includes MSDE/express versions) using TCP/IP connection
SQL 2005 (includes MSDE/express versions) using VDI connection
SQL 2008 (includes MSDE/express/SBS versions) using VSS connection

It is important to select the appropriate connection type depending on the version of SQL you are backing up. See attached screenshot.

You will need a full installation of UltraBac on both the backup server AND the SQL server.

It is important that you edit the SQL server list on both the backup server and the SQL server.

Remember to list the name of the SQL server with instance name, separated by a carrot "^" symbol if the SQL instance is a named instance.

To edit this list, navigate to manage\agents\SQL agent and choose the button labeled "edit server list."
Attached Images
File Type: jpg SQL_options.jpg (12.0 KB, 11 views)
James Dawes
UltraBac Software
Technical Support Manager