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.
Printable View
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.
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
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.
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.
So what would be the correct way of backing up CMIS