Viewing 15 posts - 166 through 180 (of 342 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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 28, 2008 at 3:52 am
Sorry, replication isn't a subject I'm familiar with.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 28, 2008 at 3:44 am
Good question. A reply to a similar question here (last post).
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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).
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 27, 2008 at 6:18 am
See http://www.sqlbackuprestore.com/backupandrestorerights.htm for required rights.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 21, 2008 at 6:26 pm
Could you please post the complete error message? Thanks.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
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...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 21, 2008 at 5:57 pm
Viewing 15 posts - 166 through 180 (of 342 total)