I'm trying to restore a database backup. The original database has replication settings.
When I do the restore using the following:
exec('RESTORE DATABASE [mydatabase] FROM DISK = ''' + @filename + ''', NOUNLOAD, REPLACE, STATS = 10')
It throws an error Database was restored, however an error was encountered while replication was being restored/removed. The database has been left offline. See the topic MSSQL_ENG003165 in SQL Server Books Online.
RESTORE could not start database
RESTORE DATABASE is terminating abnormally.
What's worst. My actual replication on my other 3 servers went offline after this...
Aucun commentaire:
Enregistrer un commentaire