UltraBac Software  

Go Back   UltraBac Software Forum > UltraBac Technical Support > SQL Agent
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Closed Thread
 
Thread Tools Display Modes
  #1  
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
James@ultrabac.com
425-644-6000
Closed Thread


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 04:35 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2001-2015 UltraBac Software