Are you re-indexing or dropping and recreating indexes ? Also, fragmentation can occur at the data page level as well, not just index pages. Here's one link to get you...

Here's what we have done at our site as a default starting point (19+ instances and 200+ databases) ... we are 95% prodution ...

tempdb data

    1024 Mb initial allocation

    growth...

yup. Database Diagram Editor. If I remember correctly they do not exist in the database when it is created. The are created "auto-magically" when you first launch the Database Diagram...

There's no need to 'fix' the database. It's most likely due to fragmentation. My guess is that you probably do not reindex or recreate tables when fragmentation gets high. To...

Since it's a potential audit/change control nightmare why not create one table with a few columns like:

sequence number (identity column unique)

database name

procedure namer

execution date

and just add one insert statement to...

As was just stated previously ... it depends on what you want to do ... but for data only there are products called Vitria and Informatica (if this is an...

I would first ask "why" ?  ... (e.g. "Are there unauthorized access to the database ?") ... just curious as to what is driving this question since there are lots of...

My guess is that you could even run it on a MAC !

But why ???

It sounds as if they are being 'penny-wise' and 'pound-foolish'. Maybe digging on a strage vendor's website (EMC or Hitachi) for white papers might help. After all who is more...

If the storage is for databases the only choice is SAN. Database backups can exist on a NAS but there is a performance hit. For optimal performance on disk database...

It may be true that some of the 'buzz' words (BrainBench, MCSE, etc.) may get you through a firms automated filtering mechanisms to get into the initial selection pool for...

No one has yet touched on something very basic. If we noe have .NET, C# and whatever else in the database, where are the runtime environments (exe's, dll's, etc) stored...

The standard DBCC triage is:

CHECKDB()

CHECKALLOC()

CHECKCATALOG()

You may also want to execute UPDATE STATISTICS and sp_recompile for each table since you'll have all of that extra time.

Have you tried:

BOL --> index --> errors-SQL Server

Some more thoughts ... just because the diferent data centers are on different backbones does not prohibit data transfer. You need to chat with the network fo0lks to find out...