SQl DB BACK UP PLANS

[IBACFII]

Ok, I didn't see a tip for this so here it goes.

1. I am to implement a wide scale SQL DB back up across multiple servers which contain multiple SQL DBs'

2. This back up "plan" is to include asp code and some vb code.

3. I would like to be able to automate this process as much as possible.

Details:
1 SQL 2000 Server - Windows Server 2003
3 SQl 7.0 Servers - Windows 2000
1 Web Server - Windows Server 2003

All servers are fairly new HP's with the exception of one that is a dell with the win2000 and sql 7.0.

Most importantly the code is what is "Critical" not the data as it is refreshed monthly. With the exception of what is on the dell. I can provide more info. I am guessing that getting help on this task is a reach but I thought that it might be worth a try.

Thanks,

IBACFII

 

[JayKusch]

At the lowest level NT Backup and Native SQL Server Backups on w/in a couple of scheduled jobs should get you were you need to be.

Of course you could go a bit further and trade out NT Backups for a 3rd party app like Veritas and gain a bit more control.

Remeber to backup up your DBs to disk first and then to tape. Faster recovery time from disc as than from tape and you do not have to go thru the headaches many of us have faced doing backups/restores from tape.

Thanks

J. Kusch

 

[Catadmin]

Look up Database Maintenance Planner in Books Online. It's a great automated DB backup, Trans Log backup, integrity check and optimization tool (IMHO). You schedule it to make backups to the same directory, then use your Windows / 3rd Party backup to backup the DB directory along with your other stuff.

Heck, just look up Database Backup in BOL and it'll give you the T-SQL commands as well in case you want to script it instead of using the DBMP.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[IBACFII]

I think that this subject could definately use a FAQ or a tip.