Backing up SQL database ?

[Kyle]

Can some one point me to a idiots guide of backing up a SQL database. That is always running.

 

Or give me a idiots guide here.

[NetworkGeezer]

It depends what the application youre using the database for.

 

Most big name backup programs have an SQL module/agent for Microsoft SQL Server 2000

 

If you're using the SQL Server for SIMS.net then you should use the backup option in System Manager or the command line utitility dbAttach.exe

[apeo]

We use Veritas to backup everything here, which is capable of backing up a live sql database. If you dont want to use 3rd party software to do it or follow Geezers suggestions then a rough way to do it is to have a batch script stop the service, backup the relavant files and start the service.

[Ric_]

You can always just use the 'Backup' command in Enterprise Manager to back it up. Run it on a schedule and dump it off to somewhere. This is the cheapest option by far.

 

Otherwise, you're looking at a couple of hundred quid for your backup program's SQL agent.

[Kyle]

So what would be the correct way of backing up CMIS

[lbradley]

DPM is very good for backing up MS applications. Just depends whether you have enough budget I suppose.

 

I presume it's MS SQL?

[Domino]

DPM is very good for backing up MS applications. Just depends whether you have enough budget I suppose.

 

I presume it's MS SQL?

 

...He's probably found a solution in the 12 years since this was asked

[lbradley]

DPM is very good for backing up MS applications. Just depends whether you have enough budget I suppose.

 

I presume it's MS SQL?

 

Whoops, sorry. Just seen the date.