One of the main things that will be lost is almost the 5.000 videos that are uploaded on PASS website...

There's any way to archive them for the future? There's to...

Thanks Kenneth

There's any other way to do this ? Don't want to use the thrustworthy

Thanks GILA 🙂

About a query to check if a file is marked as empty or not you have any ?

About the EMPTYFILE operation on same filegroup:

i have file A1 with 100GB occupied

file A2 with 20GB (autogrowth disabled)

file A3 with 30GB (autogrowth disabled)

if i make EMPTYFILE on A1 it will...

GilaMonster (9/8/2012)

---

No, you don't want to shrink in 1 MB chunks...

Create 2 new files in the filegroup, then shrink the full one with EMPTYFILE and remove it. Result - data...

about the move of extents ( data ) between the datafiles in same filegroup, theres any best practice or tutorial or tips i should follow ?

since all extents are used...

GilaMonster (9/8/2012)

---

biohug (9/8/2012)

---

i tried "DBCC SHRINKFILE (N'A1', 211689)" but took so long and gave a strange error:

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current...

I have enough space on tlog and DB is in simple mode

Log Size (MB) Log Space Used (%) Status

9993,992 ...

Brent 🙂 thanks for all the help,

i checked all that pdf tips and everything is ok with the instance and databases, theres no errors on SQL Error log 🙂

that error...

Brent you mean, execute the DBCC SHRINKFILE command to remove 1MB to the datafile each time, since all extents are used ?

DBCC CHECKDB gave no errors 🙂

Robert THANKS 🙂

Thanks for the answer Robert.

About the 1ºst advice, im not allowed to change it :/

2ºnd advice, yeah 😉

but tell me, using the current syntax, theres any expression or anything i...

there's any program that can show me this info visually ( GUI ) ?