topic Backup procedures in Server Management - Systems Insight Manager

Backup procedures

nathan_78 — Wed, 08 Mar 2006 09:49:47 GMT

What is the best practice on getting the PMP database to tape? Will it still write if it is still up and running?

Sorry if this seems basic but working with Databases is REAL new to me as far as maintence and archiveing.

Re: Backup procedures

Igor Karasik — Wed, 08 Mar 2006 14:09:23 GMT

Two options:
- Use your backup software with agent for SQL. For example, we use Symantec (ex-Veritas) backup exec with SQL agent
- Do database backup by using Maintenance Plan
http://www.databasejournal.com/features/mssql/article.php/3530486
For such backup you don't need 3-th party tools. It will create .bak file with your PMP database dump and you can write this file to tape with any backup tool.

In both cases you do online backup, you database is up and running during backup.

You need to backup tranasaction logs as well (or change recovery mode of PMP database to Simple)
http://support.microsoft.com/kb/873235/en-us

Re: Backup procedures

nathan_78 — Wed, 08 Mar 2006 14:24:36 GMT

That is exactly what I was looking for!!

Thanks