April 13, 2021 at 2:54 pm
SQL Server 2016 - Two issues when restoring database in standby mode on a test server
Looking for some help regarding following two issues -
Issue 1. Source database has replication setup
When it is restored on a test server in standby mode sp_helpreplicationdb shows it as replicated but there is no publication or anything.
sp_removedbreplication does not work because database is in read-only mode
can not update sysdatabases to set Category to zero
Can not drop database unless I take it offline
When restored without standby mode it does not show it as replicated and can drop it without any issues.
Issue 2. When it is restored with move
database files correctly get moved to proper location but sys.database_files.physical_name has the original path.
Thanks in advance
April 14, 2021 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
April 17, 2021 at 10:11 am
1) Via this software, you can successfully restore SQLite database objects like tables, indices, views, triggers, etc. Whatever, you can recover the SQLite database from corrupt .sqlite, .db & .sqlite3.
2) you can save them into a new file of SQLite or MDB format.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply