MANU (1/1/2009)

---

Normally you shouldn't shrink.

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

If you have decided then decide the target size based on how much space you want to leave in mdf file after shrink...

As I understand, we need to run SHRINKFILE twice

- First with "NOTRUNCATE" to reallocate spaces

- Second with "TRUNCATEONLY" to reduce size

Is it correct?

And how to calculate "target_size" value of SHRINKFILE?

Thanks

As about info, is it follow?

- Create a normal windows user (group Users)

- Set security rights: Read-Write for relevant folders that SQL service uses, example folder contains data file, folder...

Could you please explain me about SQL BOL?

Thank you

Steve Jones - Editor (11/2/2008)

---

You can restrict this account to only logging onto the computer running the SQL Services. Then use EM to assign this account as the service account....

I'm using SQL2000, version 2000 is still popular

I don't want to use LOCAL SYSTEM because it's said that it's not very security, LOCAL SYSTEM has right as an Administrator of...