Sql error when try to restore database.Please help me!

H

herngyih

Dear all experts,

We had just purchased a new server which I intend to use as a project
server.I named it "mustang".The existing project server named
"projectserver".I had no experience of migrating data and restore project
server in new machine.
What I did is backup the project server database "ProjectServer7348" which
is 800 over MB in size.Backup was successful.I then try to restore the db in
"mustang" enterprise manager.
My plan was to create an identical database just like the one in
"projectserver".Then install the project server in "mustang" and point it
straight to newly restored "ProjectServer7348" database.Am I doing the right
things anyway so far?
However i face a problem when restoring the database.I get this error:

"Microsoft SQL-DMO(ODBC State:42000)"

"Could not find stored procedure 'dbo.sp_MSrepl_backup_start'.
Could not adjust the replication state of database 'ProjectServer7348'.The
database was successfully restored,
however its replication state is indeterminate.See the Troubleshooting
Replication section in SQL Server Books Online.

RESTORE DATABASE successfully processed 13769 pages in 73.380 seconds(1.537
MB/sec)."

I`ve seen the store procedured created there but not any tables.Or there
ia any other way to restore my previous deployment?

Thank you in advance.
 
A

Aaron Tamblyn

This looks like a SQL Server issue related to restoring to a SQL Server with
a different configuration than the server the backup was taken from. You
would probably get a better answer posting to the SQL group. I suspect that
the existing database server is replicating databases and that 'mustang' does
not do replication. Refer to the following site for the missing system
stored proc
http://www.webtropy.com/articles/SQL.asp?SQL=sp_MSrepl_backup_start

I hope this helps.
 
Top