Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kish
Starting Member
45 Posts |
 Posted - 2004-03-05 : 05:56:36
|
| Hi,I was wondering if anyone can ever delete a primary file...i dont think so, as it contains all the system tables and for a database to remain live, it has to have a primary file and a log file.Any comments ? |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-05 : 06:04:34
|
| I think you're right. CREATE DATABASE designates the PRIMARY filegroup, thereafter you can use ALTER DATABASE to change the default filegroup but never the PRIMARY (which you can't set to Read-Only either).Raymond |
 |
|
|
|
|
|
delete primary file