Steve Jones - Editor (5/4/2010)

---

Yep, but the backup file won't be 130GB. It will be the data size (with some log records). You can copy 50GB there, restore, then shrink...

Please correct me if I am wrong, but wouldn't the restore process keep the MDF file the exact same size. As such, I am still left with a 130GB...

Well since I am one of those part-time DBA's and I am pretty sure the SSIS package for the almost 400 tables we have would take a while to build,...

Just realized I forgot one.

SQL Server 2005 Performance Dashboard Report. Based upon the internal DMV.

Fraggle

There is a tool that no one has listed and it is Free.

SSMS Tool Pack. Between this and SSMS 08, I essential get Redgate sql promt for free. ...

Can't say that I have seen any white papers or anything, but when making this decision, I look at one factor as it is really all that matters all else...

try this code and let me know how it works out.

Fraggle.

select product_n

, color_code_n

, sum(qt1) as qt1

, sum(qt2) as qt2

, sum(qt3) as qt3

, sum(qt4) as qt4

, sum(qt5) as qt5

, sum(qt6) as...

Another option for renaming a MDF/LDF file is to restore a back and use the WITH MOVE option. This will allow you to give it a new name.

Also,...

Jason,

per you suggestions, I removed the options for NoTruncate and TruncateOnly.

Still does not shrink. Output is as follows.

DbIdFileIdCurrentSizeMinimumSizeUsedPagesEstimatedPages

125129565184128 ...

Alright, so I know have 3 seperate people telling me that dbcc shrinkfile will shrink the file lower than the inital file size.

However, if you read my first post, I...

Thankfully no. Just on a test server

Fraggle

OK, now I am a bit lost. Apparently, altering the database to modify the file to a smaller size throws an error stating that the size I am trying to...

FileSizeMBUsedSpaceMBUnusedSpaceMBDBFileName

230980.0086836.75 ...

Thanks for the link. I will give it a try this evening an let you know.

Fraggle

I am sure someone will correct me if I am wrong, but I don't think this is possible from tsql. The reason it is possible from a DTS package,...