atricapilla
Reputation: 2630
Rename database files: drop tables?
I would like to rename database files (.mdf ja .ldf) in SQL Server. Do I have to drop all tables from the database before that?
Upvotes: 0
Views: 147
Answers (2)
gbn
Reputation: 432261
No.
To rename database and files..
- detach databases
- rename files
- attach with another name
Upvotes: 3
Related Questions
- SQL Server Renaming Tables
- SQL Server Rename DB and Attached Files
- Rename database data file in SQL Server 2005
- SQL Server rename table with name start #
- Renaming multiple tables
- Drop databases with no tables
- How to Rename a Database without losing data?
- Rename all tables in database
- Drop all tables in a SQL Server database from Batch file?
- Best way to remove all tables from a sql 2005 database