Viewing 15 posts - 166 through 180 (of 341 total)
The 'type' column in msdb..backupset identifies the various different backups that have been made. Either you are not using the SQL Server BACKUP command to perform your backups (perhaps...
August 28, 2008 at 3:52 am
Sorry, replication isn't a subject I'm familiar with.
August 28, 2008 at 3:44 am
Good question. A reply to a similar question here (last post).
August 28, 2008 at 1:30 am
Look in the msdb..backupset table. It contains details of backups (database name, backup type, backup size, backup date etc).
August 28, 2008 at 12:17 am
you can also backup the transaction with truncate_only or no_log option:
That's not going to help as the entire load is performed in a single transaction. The transaction log...
August 27, 2008 at 8:40 pm
To Stuart:
Perhaps you have an old transaction that's still open, that's preventing the transaction log from being truncated. Run DBCC OPENTRAN to check if this is the case.
As to...
August 27, 2008 at 6:18 am
See http://www.sqlbackuprestore.com/backupandrestorerights.htm for required rights.
August 27, 2008 at 6:08 am
ASSUMING THAT SQL SERVER ALSO STORES THE CONNECTION INFO OF EACH TRANSACION IN THE LOG FILE...........
Sort of, see here.
when will sql server perform that activity (that connection is lost...
August 22, 2008 at 8:03 am
Sorry for the confusion.
The active part of a transaction log is the portion that cannot be truncated. If you have the following transactions:
A B C D E F G...
August 22, 2008 at 2:08 am
1 -stay calm.
2 - what is your database's recovery model? If it's simple, see 3). For full and bulk-logged, see 4).
3 - two possibilities
3a. you have an...
August 21, 2008 at 6:50 pm
Run a checkpoint, followed by DBCC DROPCLEANBUFFERS. That's database wide. I think there is an option to clear the buffer pool per database, but I can't recall the...
August 21, 2008 at 6:26 pm
Could you please post the complete error message? Thanks.
August 21, 2008 at 6:21 pm
...is the five inserted records are still present in the Transaction Log.
Yes. See this document on when log records are created in the transaction log.
... when will these...
August 21, 2008 at 6:20 pm
>> So will the TLog backup contain the transactions between 6:00 & 6:05 or not?
Yes. A full database backup and a transaction log backup will always contain the...
August 21, 2008 at 6:09 pm
which TLog backup should be we keep then, the first backup that removed only the last logical file , or the second backup that shrinks the size
I'm not following you...
August 21, 2008 at 5:57 pm
Viewing 15 posts - 166 through 180 (of 341 total)