Hi All
I have 3 datafile & 5 log files for a database, not sure if these LOG files really have any data.
I remember somebody saying there is an way to move the data from these 5 LOG files to a single LOG file & deleting the 4.
Can somebody help me on how to accomplish this.
ThanksSee dbcc shrinkfile with emptyfile.
After this the file can be deleted using alter database
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment