I'm a newbie DBA, and administer a SQL Server with 5 gigs worth of
decision support data (data is bcp'edin a daily-weekly-monthly basis).
I also have a test server,on a separate machine, that contains a mirror
image of what is on the production server. Is it safe to use this
server as a 'backup' to the production machine. Everynight I do batch
updates back and forth to keep information current on both machines. If
I do use it as a backup, what isssues should I be aware of?
Thanks in advance,
- Karl Martino