5
votes
How to tell Microsoft SQL Server Management Studio that a DB rename must be done completely
It sounds like the names of each database are not largely important, as you've mentioned they're copies you've restored to your local PC. If that's the case, a much easier approach may be to rename ...
- 3,219
5
votes
How to tell Microsoft SQL Server Management Studio that a DB rename must be done completely
This is how it is designed by Microsoft, if you rename database only database name changes - neither logical nor physical name changes. This is described in the documentation Rename a Database - ...
- 3,752
3
votes
Accepted
SQL Server fix deleted mdf
The normal process to recover from a storage failure is to backup the tail of the log (if possible), restore from your last full backup, restore the most recent differential backup (if you do those), ...
- 24.5k
Only top scored, non community-wiki answers of a minimum length are eligible