OOPS, type error:

It should be:

I...

The size of your logfile has no effect on your full backup, neither has the recovery model. The full backup is a copy of your data and indexes (actually what's...

If your initial size has gone back to 1, you probably have autoshrink on. If you don't allow autogrowth (which i don't recommend), don't enable shrink (you'll only have the...

You can have multiple filegroups and multiple datafiles in a filegroup, but you must have a filegroup called primary with at least one datafile.

The first datafile has the extension of...

Are forward pointers always limited to the same physical file, or can you point to a location in another file (within the same filegroup)?

Table Name Rows Reserved (KB) Data (KB) Index Size (KB) UnUsed (KB)

Table1...

Is seems that NIManagementDB is watching your transactionlogfile and registers when this file needs to expand. If this file expands > 4 times in an hour(?), it's complaining (This is...

Your disk is becoming a bottleneck:

Several processes are struggeling for I/O completion on...

Yes, that should work. Make sure you add the NORECOVERY parameter to eacht restore statement, until you're at the latest logfilebackup. Restore that backup with the RECOVERY parameter.

I stronly advise...

CU9 is already available and according to Microsoft, CU10 is currently build :hehe:

Vote for SP3! 🙂

Tip: to check if your SQL is up-to-date: http://support.microsoft.com/kb/937137

The recovery model doesn't affect the full backuptime, it only eliminates the need for logbackup in case you have a SIMPLE recovery model.

If you're running out of backup time, you...

Very interesting question!

Here are my 5 cents:

- Use a 64bit Enterprise environment

- Use a SAN with a lot of disks

- Which backup solution are you gonna use? (backuptime,...

Make sure you download the freeware version.

SQL Express doesn't have a job scheduler. SQLSafe comes with an commandline utility and several stored procedures. So you have the choice of scheduling...

Thanks for your input. Thus: forwarding pointers can only occur on heaps, while page splits only occur on indexes?

Other tip: While your PDF is on your screen, go to your internet cache directory and copy the PDF file