September 3, 2003 at 4:35 am
Guys,
I have a database (2000 version) that the data file grow so large. I have shrink the file using shrinkfile command. Do any one know or has a script that can help me shrink the file? I have no problem shrinking the log.
September 3, 2003 at 4:50 am
Hi control,
quote:
I have a database (2000 version) that the data file grow so large. I have shrink the file using shrinkfile command. Do any one know or has a script that can help me shrink the file? I have no problem shrinking the log.
could you provide more information about file properties of your data file?
File Growth?
Maximum File Size?
Sudden Growth or steady growth
In addition, have you tried DBCC SHRINKDATABASE ?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
September 4, 2003 at 1:05 am
Use DBCC SHRINKFILE and read BOL for explain
****************************************
1: The question is ... "What is a MahnaMahna"?
2: The question is ... "Who cares?"
****************************************
September 4, 2003 at 7:07 pm
If you've tried shrinkfile with no luck, Make sure you don't have long running transactions, check out dbcc opentran.
HTH
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
September 5, 2003 at 8:48 am
Try going to this old post. Scotlinkon had an interesting approach using an emptyfile. It's worth trying in a test.
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply