Viewing 15 posts - 91 through 105 (of 342 total)
Now another question is, how does one measure memory used by such a filter driver while it is running
Sorry, I don't know how. Interesting though, that Litespeed Engine seems...
September 18, 2010 at 1:32 am
using existing SQL scripting, it intercepts defined file extensions and compresses them
If it does that, it's probably using a callback filter e.g. here[/url]. In that case, it's a process...
September 17, 2010 at 5:21 am
The PASSWORD option in the BACKUP command simply requires that you provide a password during the restore process. It does nothing to obfuscate the contents of the backed up...
September 15, 2010 at 9:19 pm
There are 3rd party tools that can recover individual objects from a backup file, like Red Gate's SQL Object Level Recovery Native, if restoring the entire database is not an...
September 15, 2010 at 9:15 pm
I'm not familiar with the 'Backup' object, but it doesn't look like you're overwriting the existing backup file. As mentioned in the error message, you should use the WITH...
September 11, 2010 at 10:04 am
CheckpointLSN of full backup = DatabaseBackupLSN of differential backup ( http://www.sqlbackuprestore.com/logsequencenumbers.htm)
September 4, 2010 at 6:28 pm
August 28, 2010 at 12:56 am
That script won't work on SQL Server 2000. You did post on a SQL Server 2005 forum after all.
Run sp_who2, find if the BACKUP processes are being blocked, if...
August 24, 2010 at 5:23 am
If the SQL Server instance is already writing to the error log successfully, but still raises that error in the event log, it's mighty strange. Sorry, I'm out of...
August 22, 2010 at 3:56 am
As per this page, error code 21 = 'The device is not ready.'. Can the node running the SQL Server instance access the T:\ path?
August 22, 2010 at 2:01 am
Q3 - under Restrictions, it says that Compressed and uncompressed backups cannot co-exist in a media set.
By media set, the docs mean a backup file. Once a backup...
July 30, 2010 at 8:33 pm
The only reason I can think of for the rapid growth of the logs is that developers are importing lots of external data, which is all being recorded by the...
July 27, 2010 at 7:16 pm
We use that to determine the theoretical maximum backup throughput of the database, since your backup can only be as fast as what SQL Server can read from disk during...
July 26, 2010 at 6:21 am
At the lowest level, there is the data file (.mdf). Assuming it's created on an empty disk, the initial physical layout of the file should not be fragmented. ...
July 26, 2010 at 5:34 am
Viewing 15 posts - 91 through 105 (of 342 total)