Hot answers tagged

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 ...
user avatar
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 - ...
user avatar
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), ...
user avatar
  • 24.5k

Only top scored, non community-wiki answers of a minimum length are eligible