Move data in data file to another data file and drop existing

Last Post 20 Jun 2007 01:46 AM by marchantb. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
marchantb
New Member
New Member

--
19 Jun 2007 11:25 PM
Hi,

I'm looking for a command/code to move data in an existing data file to another data file and then to drop the first data file from the database.

Any help or advise will be appreciated.

Thanks
marchantb
New Member
New Member

--
20 Jun 2007 01:46 AM
Thanks. I see it can be done through ... DBCC SHRINKFILE('file_name', EMPTYFILE)
You are not authorized to post a reply.

Acceptable Use Policy