HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
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