During the backup, does the kernel memory values (as viewed using the Windows Task Manager) increase linearly?

If you look at the screenshot before the paragraph that contained that statement, you will see that there were...

See if this document helps.

When you restore the transaction logs to the secondary database, you can specify that the database be in one of two modes: offline or read-only (step 7 in this document)....

That would be the (db_backupoperator) role.

A kill command, although returning immediately, still rolls back any transactions associated with the killed spid.

A snapshot reflects the state of the database at the time the snapshot was made. Subsequent changes to the source database are not reflected in the snapshot.

To revert the...

From 'Pro SQL Server 2005 High Availability' by Allan Hirt:

In my experience, 9.9 out of 10 times, an OS-based backup is not equivalent to detaching a database, let alone a...

Try setting the database offline just before restoring it e.g.

USE master

ALTER DATABASE EXP_TRAIN SET OFFLINE WITH ROLLBACK IMMEDIATE

RESTORE DATABASE [EXP_TRAIN] FROM [filer04] WITH ...

Native SQL Server backups utilize very little CPU resources, but disk I/O is another story. While the drive volumes may...

Not required for the full database backup, as it does not break the log restore chain in...

I've encountered a similar issue with sysdatabases, where running 2 consecutive queries against that catalog view yielded different results, although the state of the databases has not changed. You...

In addition to regularly backing up the transaction log, you need to ensure that transactions are committed or rolled back as soon as possible. Otherwise, the active portion of...

Having multiple data files on physically different disks will result in faster read throughput during backups(http://www.sqlbackuprestore.com/backupreadsandwrites.htm).

I think you need to distinguish between index statistics and column statistics.

Index statistics are those statistics for a specific index, that get generated regardless of the AUTO_UPDATE_STATISTICS setting. These...