cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Backup Exec to Sync SQL Test Server?

ChezVeritas
Level 2

‎01-31-2005 02:56 AM

A client of mine is currently running SQL Server 2000 on W2k3 with Backup Exec 9.1 and the SQL Agent.

The databases are not huge and will only require a full database backup each night.

They have one live and one test server and want to keep a full backup copy of the live db on the test server for patch testing and as a standby in case of failure.

Could Backup Exec 9.1 be used to backup the live db and then restore it to the test server, creating a completely separate, but identical database on the test server or would tools like SQL Compare be better for this?

Thanks in advance
Chez
0 Kudos
1 REPLY 1

Ameet_Thakkar
Level 6

‎02-01-2005 07:14 PM

You can redirect a full database backup to a different server or database


Kindly refer Backup Exec v9.1 administrative manual from page # 1018.

VERITAS Backup Exec (tm) 9.1 for Windows Servers Administrator's Guide (English)



http://seer.support.veritas.com/docs/266190.htm

We hope this helps.
0 Kudos