- You did a good assessment of your options.

- As you know, clustering is mainly to overcome hardware failures.

The big advantage is that it is addressable using the...

It is indeed something you need to know about when trying to handle the files.

BOL has good info at http://msdn.microsoft.com/en-us/library/ms178037%28SQL.90%29.aspx

shrinking a log file will not move log data !

A log file can only be shrunk to the last active virtual log !

Hence, you may have to execute the shrink...

Whenever I move sqlserver files, I always xcopy the current folders (without files) to the new location including the authorisations !

(/O parameter)

I'm sure ROBOCOPY will also have such an option.

You...

- You can expect the log file to be as big as the data file, depending on how "intelligent" your perform index rebuilds.

- If someone performed massive updates, e.g. implemented...

- sys.configurations is the source system object for sp_configure.

It is a system object, so where it gets it data from shouldn't matter.

(you can nolonger update catalog tables directly)

- AFAIK the...

Best is to work with minimal rights.

So go for the solution provided by K. Brian Kelley !

But as a little safeguard, you could implement a database trigger to only allow...

Have you run dbcc checkdb lately ?

I always use shrinkfile in stead of shrinkdb.

(what are the sizes of your db files)

Keep in mind your shrink operation will perform heavy...

Nice article !

This is a time saver !

Thank you for sharing the experience.

- that would be a table with +- 4,000,000,000 rows .... nice

- double check you have an index on that identity column

- Make sure you use the propper technique to...

set identity_insert is at session level !

So it will only be active with your session for your session !

Why are you trying to fill the gaps ?

Are you reaching the...

for sql2000 the current service pack is sp4. (and at least sp2 is required with win 2003).

for sql2005 the current service pack is sp3.

you could generate your drop statements using this query

Select *

from sysobjects

where xtype = 'u'

and category = 0 --(in sql2005 that would become is_ms_shipped = 0)

order by name

Doublecheck you...

isabel (7/13/2009)

---

My schedule for backup is already stable. Full backups every sunday night, and differential backups from Monday to Saturday nights.

Now I have problem with performing my regular restore...

With partitioned objects, I would avoid nonaligned indexes !

(because it may narrow down features and options to perform tasks.)

Unless you can prove performance is better with a nonaligned index to...