Two SQL Server databases setup with same .mdf and .ldf files

1 vote

1 answer

4141 views

sql-server sql-server-2008-r2 ssms files attach

                          In a SQL Server 2008 R2 instance two databases (the second one being a restore/copy of the first one) have been setup against the same .mdf and .ldf files. 

How would I go about either deleting the second one or copying/moving the files for the second one without affecting the first (production!) db?

Update: Indeed one of them is Standby/Read-Only.

Asked by Eirik H (113 rep)

Jul 11, 2014, 06:50 AM
Last activity: Jul 24, 2019, 09:31 PM

Two SQL Server databases setup with same .mdf and .ldf files

Related Questions