EMPTYFILE -- sql server (alternate)

karora NO[at]SPAM melstar.com
2/13/2004 1:52:55 AM

When I move data from one .NDF file(20 GB) to some .NDF file on some
other drive using DBCC SHRINKFILE using EMPTYFILE entire 20 GB data
first goes to transaction log. Transaction log space is only 5 GB.

We are aware of other way of moving data like DTS/bcp etc. Please tell
us if the above can be done without using t.log..

Simon Hayes
2/13/2004 6:56:22 PM

[quoted text, click to view]

You could detach the database, copy the NDF to the new location, and then
attach the database again. This would avoid using the transaction log
completely, but of course the database would not be available. See
sp_detach_db and sp_attach_db in Books Online.

Simon

sql server (alternate) : EMPTYFILE