Moving NDF files to different location in sql 2005

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Robert Klimes SSCoach Points: 17865 More actions · Answer 1

Easiest way to do so is to detach database, move file, then re-attach.

Bob
-----------------------------------------------------------------------------
How to post to get the best help[/url]

homebrew01 SSC Guru Points: 55548 More actions · Answer 2

Be sure that there is no activity on the database first because they will get disconnected.

Victor Alvarez-1138365 SSC-Addicted Points: 494 More actions · Answer 3

How to move log files in details

Victor Alvarez
http://sqlpost.blogspot.com

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 4

SSCrazy Eights

Points: 9210

August 7, 2009 at 4:22 pm

Thanks guys,

Appreciated.