Recovering from Project 2003 backups and marked transactions

[joker197cinque]

I have a microsoft project 2003 environment and I can see 3 db:

projectserver
sts_projectxx_1
wssconfigdb

As DBA I was asked to ensure a disaster backup/restore procedure for
these 3 db.

I'm reading "Project Server 2003 Disaster Recovery Guide" and reached
this point about recovering sql 2000 database:

"Recovering to an Earlier Point in Time"

it is split into 2 scenarios:

Recovering a Single-Database Deployment
and
Recovering a Multiple-Database Deployment

I think (but I don't really know) the second scenario is much more
appropriate, so I get into these steps:

To recover to a marked transaction
1. Restore your backups of the Master and Msdb databases.
2. Restore the most recent full database backup.
3. Restore any differential database backups that were created since
the most recent full backup.
4. Recover the database at the specified marked transaction within a
transaction log backup. You must use the Transact-SQL RESTORE LOG
statement and the WITH STOPATMARK='mark_name' clause to restore to a
named mark.
Note For more information about recovering a database to a marked
transaction, see the topic Recovering to a Named Transaction in SQL
Server 2000 Books Online, or on the Microsoft Web site (http://
go.microsoft.com/fwlink/?LinkId=19691).
5. Repeat steps 2 through 4 for each database in your deployment,
recovering each to the same named mark.

What I can't understand is:

1. Does Project server insert its marked transactions? If yes, what is
the name?
2. In fact I can't find any: if I query select * from
msdb..logmarkhistory; I can't see any rows...is it correct?

Any way, what sholud be the most secure procedure to backup/restore
this kind of environment??

Any help really appreciated.

Best regards.

 

[Gary L. Chefetz [MVP]]

It doesn't sound the multiple database option applies in your case. This
refers to a deployment type, not a database count. Unless you are performing
incremental backups, you can't recover to a point a in time other than the
last full backup. If you have questions about SQL backups, setting them up
or setting-up scheduled backups, you should ask them in the appropriate SQL
newsgroup.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com