September 8, 2009 at 1:05 am
can we shrink the primary data file ?
September 8, 2009 at 1:10 am
ramyours2003 (9/8/2009)
can we shrink the primary data file ?
You can using dbcc shrinkfile to shrink a file.
have a good reason though for doing it, as shrinking a database will result in performance degradation as you will be fragmenting indexes.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 8, 2009 at 1:26 am
can we shrinkthe primary datafile i.e the mdf file
September 8, 2009 at 1:27 am
before shrinking can we take backup of the file ?
September 8, 2009 at 1:28 am
yes you can do both. you can backup before you shrink if you want to.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply