Backup procedures

[nathan_78]

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.

[Igor Karasik · Accepted solution]

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

[nathan_78]

That is exactly what I was looking for!!

Thanks