Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

Backup procedures

SOLVED
Go to solution
nathan_78
Advisor

Backup procedures

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.

2 REPLIES
Igor Karasik
Honored Contributor
Solution

Re: Backup procedures

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
Advisor

Re: Backup procedures

That is exactly what I was looking for!!

Thanks