mercredi 4 mai 2016

Restore database backup avoiding replication

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