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 |
|
chetancool
Starting Member
34 Posts |
 Posted - 2004-10-09 : 04:02:20
|
| Hi group..This is chetan.I have joined a new firm and over here, there is mess up in the database files and log files.Here, data files are splitted in three files under primary file group.Same goes for transaction log als. Log file is splitted in 4 files.Now, i want to delete the addition data files. i m using the shrink database option - empty data file(move data to other files in the group). i m having sufficient space in the other data files.my question is that .. can addition data file can be fully emptied so that i can delete the file?Plz helpcjain |
|
|
sify
Starting Member
18 Posts |
Posted - 2004-10-12 : 04:42:44
|
| Are you talking about the dbcc shrinkfile (filename|fileid,targetpercent,emptyfile)? |
 |
|
|
|
|
|
Filegroup Management