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
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