Viewing 15 posts - 181 through 195 (of 341 total)
During the backup, does the kernel memory values (as viewed using the Windows Task Manager) increase linearly?
August 21, 2008 at 10:16 am
active log record is in the second to last virtual log file
If you look at the screenshot before the paragraph that contained that statement, you will see that there were...
August 21, 2008 at 9:04 am
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)....
August 20, 2008 at 4:44 am
You can give them the database role for backup (db_backupadmin) for their database only.
That would be the (db_backupoperator) role.
August 18, 2008 at 10:21 am
A kill command, although returning immediately, still rolls back any transactions associated with the killed spid.
August 18, 2008 at 3:05 am
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...
August 16, 2008 at 7:35 am
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...
August 15, 2008 at 7:15 am
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 ...
August 14, 2008 at 9:02 pm
backup's doesnt leave any performance affect on the system.
Native SQL Server backups utilize very little CPU resources, but disk I/O is another story. While the drive volumes may...
August 13, 2008 at 6:29 pm
If you are running these backups out of sequence, use the COPY_ONLY command ...
Not required for the full database backup, as it does not break the log restore chain in...
August 13, 2008 at 8:48 am
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...
August 12, 2008 at 11:11 pm
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...
August 7, 2008 at 11:24 pm
Having multiple data files on physically different disks will result in faster read throughput during backups(http://www.sqlbackuprestore.com/backupreadsandwrites.htm).
August 7, 2008 at 6:10 pm
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...
August 7, 2008 at 1:39 am
Viewing 15 posts - 181 through 195 (of 341 total)