Project 2003 Logmark Transaction logs

I

indytoatl

I have one server running Project Server 2003, Windows Sharepoint
Services 2.0 and SQL 2005.
SQL 2005 Default Instance name.

Servername: ProjectSvr01
Database Name:
-ProjectServer
- WSSContentDB
- WSSConfigDB


Can anyone tell me how to get these three procedures working? The MS
Diaster Recovery documention is incomplete and so vague I can't
understand it.

Use <database>
Create Table LogMarks

(
logmark tinyint
)
GO
Insert Into LogMarks (logmark) VALUES (1)
GO


Create Procedure sp SetMark
@name nvarchar (128)
As
Begin Transaction @name WITH MARK
Update <datebase>.dbo.LogMarks SET logmark = 1
Commit Transaction
GO

Create Procedure sp MarkAll
@name nvarchar (128)
As
Begin Transaction
Exec spring.ProjectServer.dbo.sp SetMark @name
Exec bleeker.ProjectServerViews.dbo.sp SetMark @name
Exec astor.WSSConfigDB.dbo.sp SetMark @name
Exec astor.STS astor 1.dbo.sp SetMark @name
Commit Transaction
GO
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top