Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ewe1d@yahoo.de
Starting Member
17 Posts |
 Posted - 2004-11-04 : 05:25:01
|
| Hi,does anyone have experience or know any links about configuring ARCServe (hardware-assisted) backups for SQL Server? This is a failover cluster which will use a RAID1 on a SAN.ThanksChidd |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-04 : 16:20:28
|
| Why would you want to use ARCServer to backup your SQL Server databases? Why not just use BACKUP DATABASE and BACKUP LOG within SQL Server?Tara |
 |
|
|
ewe1d@yahoo.de
Starting Member
17 Posts |
Posted - 2004-11-05 : 02:46:15
|
| Hi,I was under the impression you could do things like hardware-assisted backups directly on the SAN with ARCserve. This would make backup (and also recovery) occur in seconds (good for high-availability). I've only read the docu (no pratcical experience hence Q in forum). I also know you have to install an extra agent so SQL server knows its being backed up.Obviously the other option is to run BACKUP DATABASE and BACKUP LOG in T-SQL and use ARCServe to copy the backup sets off the prod. server. |
|
|
|
zFudge
Starting Member
12 Posts |
Posted - 2004-11-05 : 05:41:44
|
| Which version of windows do you use? In windows 2003 you can choice to use Shadow Copy to backup your database. Otherwise you need to install the arcserve sql agent on the server. On the Arcserve cd is a pdf that descibs the agent |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-05 : 07:27:33
|
| I can tell you from past experience, ARCServe and SQL Server don't get along AT ALL. Can't say what the current version might do, but 1-2 years ago it was awful. You might do better, but you'd be lucky. We ended up dumping it and went to regular SQL backups (now using SQL LiteSpeed, awesome product) |
|
|
|
zFudge
Starting Member
12 Posts |
Posted - 2004-11-05 : 08:10:21
|
| The sql agent is approved in brightstore 9. It still sucks. I rather go with sql backup. Or shadow copy of microsoft Windows 2003. Shadow copy makes an offline copy of the database (snapshot) and you can backup that as an file. If you need to restore it and attach it again.Works great. (also for exchange and other open file systems/databases) |
|
|
|
rdaunce
Starting Member
7 Posts |
Posted - 2004-11-05 : 09:59:36
|
| I use Brightstor Arcserve Backup 11 on all of my servers. I only use the SQL Backup agent for one SQL server and that is a clustered server.In addition to the SQL agent I also schedule BACKUP DATABASE (daily) / LOG (every 15 min). I keep 3 days archived with this method and can use these most of the time when I need to do a restore. I backup Arcserve in a GFS routine, so I have Arcserve backups that are up to a year old. These are useful if I need historical data.I would definitely recommend against using Arcserve to backup SQL. I have always had difficulties restoring an SQL database through Arcserve. If I had to make the decision again, I would only plan on using Arcserve for file backup and the SQL Agent would not have been purchased.If I had to make a recommendation I would tell you to ditch Arcserve SQL Agent and schedule regular BACKUP DATABASE / LOG. Once you have these backups from SQL in files you can have Arcserve pick them up via a file backup.--Bob |
|
|
|
|
|
|
ARCServe SQL Backups