Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
does it have options for differential backup?
Q2: When using All Tasks\Backup Database, Why don't I have option
Remove the files older than
Q3: Does performing a Full database backup through Enterprise manager
automatically remove the inactived portion in the log file (or the portion
has been committed and written to the database)? It is grayed out in both
Full DB backup and Diff Backup. It is only available in Log backup.
Q4: How do you define "inactive entries"?
ThanksFrankie,
First, I suggest you read up on the BACKUP and RESTORE commands in Books Onl
ine. Backup is such an important
topic, and you don't want to be in a position where you need to do restore a
nd realize that your backup
strategy causes you to loose more data than acceptable. Having said that:
> Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
> does it have options for differential backup?
I assume you meant to say "doesn't it have". Maint Wiz is a basic tool. It w
as never designed for more than
the simpler scenarios. It is very difficult to answer "why?" questions. Some
one in the design team at MS made
that decision, quite simply. Probably to make the Maint Plan easier to under
stand for beginners.
> Q2: When using All Tasks\Backup Database, Why don't I have option
> Remove the files older than
Because this is an immediate dialog.
> Q3: Does performing a Full database backup through Enterprise manager
> automatically remove the inactived portion in the log file (or the portion
> has been committed and written to the database)? It is grayed out in bo
th
> Full DB backup and Diff Backup. It is only available in Log backup.
Only transaction log backup empties the transaction log. This is in order fo
r a db backup to not break the log
backup chain sequence.
> Q4: How do you define "inactive entries"?
Transaction log records generated by transactions that are committed, and th
ere is no earlier non-committed
transaction. These are not required for SQL server to perform a possible lat
er rollback for any user.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Frankie" <Frankie@.discussions.microsoft.com> wrote in message
news:9FCB61BB-9A54-4FD9-B948-5229E9F7742E@.microsoft.com...
> Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
> does it have options for differential backup?
> Q2: When using All Tasks\Backup Database, Why don't I have option
> Remove the files older than
> Q3: Does performing a Full database backup through Enterprise manager
> automatically remove the inactived portion in the log file (or the portion
> has been committed and written to the database)? It is grayed out in bo
th
> Full DB backup and Diff Backup. It is only available in Log backup.
> Q4: How do you define "inactive entries"?
> Thanks
Showing posts with label backup. Show all posts
Showing posts with label backup. Show all posts
Monday, March 12, 2012
Qs on SQL Server backup using Enterprise Manager
Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
does it have options for differential backup?
Q2: When using All Tasks\Backup Database, Why don't I have option
Remove the files older than
Q3: Does performing a Full database backup through Enterprise manager
automatically remove the inactived portion in the log file (or the portion
has been committed and written to the database)? It is grayed out in both
Full DB backup and Diff Backup. It is only available in Log backup.
Q4: How do you define "inactive entries"?
ThanksFrankie,
First, I suggest you read up on the BACKUP and RESTORE commands in Books Online. Backup is such an important
topic, and you don't want to be in a position where you need to do restore and realize that your backup
strategy causes you to loose more data than acceptable. Having said that:
> Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
> does it have options for differential backup?
I assume you meant to say "doesn't it have". Maint Wiz is a basic tool. It was never designed for more than
the simpler scenarios. It is very difficult to answer "why?" questions. Someone in the design team at MS made
that decision, quite simply. Probably to make the Maint Plan easier to understand for beginners.
> Q2: When using All Tasks\Backup Database, Why don't I have option
> Remove the files older than
Because this is an immediate dialog.
> Q3: Does performing a Full database backup through Enterprise manager
> automatically remove the inactived portion in the log file (or the portion
> has been committed and written to the database)? It is grayed out in both
> Full DB backup and Diff Backup. It is only available in Log backup.
Only transaction log backup empties the transaction log. This is in order for a db backup to not break the log
backup chain sequence.
> Q4: How do you define "inactive entries"?
Transaction log records generated by transactions that are committed, and there is no earlier non-committed
transaction. These are not required for SQL server to perform a possible later rollback for any user.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Frankie" <Frankie@.discussions.microsoft.com> wrote in message
news:9FCB61BB-9A54-4FD9-B948-5229E9F7742E@.microsoft.com...
> Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
> does it have options for differential backup?
> Q2: When using All Tasks\Backup Database, Why don't I have option
> Remove the files older than
> Q3: Does performing a Full database backup through Enterprise manager
> automatically remove the inactived portion in the log file (or the portion
> has been committed and written to the database)? It is grayed out in both
> Full DB backup and Diff Backup. It is only available in Log backup.
> Q4: How do you define "inactive entries"?
> Thanks
does it have options for differential backup?
Q2: When using All Tasks\Backup Database, Why don't I have option
Remove the files older than
Q3: Does performing a Full database backup through Enterprise manager
automatically remove the inactived portion in the log file (or the portion
has been committed and written to the database)? It is grayed out in both
Full DB backup and Diff Backup. It is only available in Log backup.
Q4: How do you define "inactive entries"?
ThanksFrankie,
First, I suggest you read up on the BACKUP and RESTORE commands in Books Online. Backup is such an important
topic, and you don't want to be in a position where you need to do restore and realize that your backup
strategy causes you to loose more data than acceptable. Having said that:
> Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
> does it have options for differential backup?
I assume you meant to say "doesn't it have". Maint Wiz is a basic tool. It was never designed for more than
the simpler scenarios. It is very difficult to answer "why?" questions. Someone in the design team at MS made
that decision, quite simply. Probably to make the Maint Plan easier to understand for beginners.
> Q2: When using All Tasks\Backup Database, Why don't I have option
> Remove the files older than
Because this is an immediate dialog.
> Q3: Does performing a Full database backup through Enterprise manager
> automatically remove the inactived portion in the log file (or the portion
> has been committed and written to the database)? It is grayed out in both
> Full DB backup and Diff Backup. It is only available in Log backup.
Only transaction log backup empties the transaction log. This is in order for a db backup to not break the log
backup chain sequence.
> Q4: How do you define "inactive entries"?
Transaction log records generated by transactions that are committed, and there is no earlier non-committed
transaction. These are not required for SQL server to perform a possible later rollback for any user.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Frankie" <Frankie@.discussions.microsoft.com> wrote in message
news:9FCB61BB-9A54-4FD9-B948-5229E9F7742E@.microsoft.com...
> Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
> does it have options for differential backup?
> Q2: When using All Tasks\Backup Database, Why don't I have option
> Remove the files older than
> Q3: Does performing a Full database backup through Enterprise manager
> automatically remove the inactived portion in the log file (or the portion
> has been committed and written to the database)? It is grayed out in both
> Full DB backup and Diff Backup. It is only available in Log backup.
> Q4: How do you define "inactive entries"?
> Thanks
Qs on SQL Server backup using Enterprise Manager
Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
does it have options for differential backup?
Q2: When using All Tasks\Backup Database, Why don't I have option
Remove the files older than
Q3: Does performing a Full database backup through Enterprise manager
automatically remove the inactived portion in the log file (or the portion
has been committed and written to the database)? It is grayed out in both
Full DB backup and Diff Backup. It is only available in Log backup.
Q4: How do you define "inactive entries"?
Thanks
Frankie,
First, I suggest you read up on the BACKUP and RESTORE commands in Books Online. Backup is such an important
topic, and you don't want to be in a position where you need to do restore and realize that your backup
strategy causes you to loose more data than acceptable. Having said that:
> Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
> does it have options for differential backup?
I assume you meant to say "doesn't it have". Maint Wiz is a basic tool. It was never designed for more than
the simpler scenarios. It is very difficult to answer "why?" questions. Someone in the design team at MS made
that decision, quite simply. Probably to make the Maint Plan easier to understand for beginners.
> Q2: When using All Tasks\Backup Database, Why don't I have option
> Remove the files older than
Because this is an immediate dialog.
> Q3: Does performing a Full database backup through Enterprise manager
> automatically remove the inactived portion in the log file (or the portion
> has been committed and written to the database)? It is grayed out in both
> Full DB backup and Diff Backup. It is only available in Log backup.
Only transaction log backup empties the transaction log. This is in order for a db backup to not break the log
backup chain sequence.
> Q4: How do you define "inactive entries"?
Transaction log records generated by transactions that are committed, and there is no earlier non-committed
transaction. These are not required for SQL server to perform a possible later rollback for any user.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Frankie" <Frankie@.discussions.microsoft.com> wrote in message
news:9FCB61BB-9A54-4FD9-B948-5229E9F7742E@.microsoft.com...
> Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
> does it have options for differential backup?
> Q2: When using All Tasks\Backup Database, Why don't I have option
> Remove the files older than
> Q3: Does performing a Full database backup through Enterprise manager
> automatically remove the inactived portion in the log file (or the portion
> has been committed and written to the database)? It is grayed out in both
> Full DB backup and Diff Backup. It is only available in Log backup.
> Q4: How do you define "inactive entries"?
> Thanks
does it have options for differential backup?
Q2: When using All Tasks\Backup Database, Why don't I have option
Remove the files older than
Q3: Does performing a Full database backup through Enterprise manager
automatically remove the inactived portion in the log file (or the portion
has been committed and written to the database)? It is grayed out in both
Full DB backup and Diff Backup. It is only available in Log backup.
Q4: How do you define "inactive entries"?
Thanks
Frankie,
First, I suggest you read up on the BACKUP and RESTORE commands in Books Online. Backup is such an important
topic, and you don't want to be in a position where you need to do restore and realize that your backup
strategy causes you to loose more data than acceptable. Having said that:
> Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
> does it have options for differential backup?
I assume you meant to say "doesn't it have". Maint Wiz is a basic tool. It was never designed for more than
the simpler scenarios. It is very difficult to answer "why?" questions. Someone in the design team at MS made
that decision, quite simply. Probably to make the Maint Plan easier to understand for beginners.
> Q2: When using All Tasks\Backup Database, Why don't I have option
> Remove the files older than
Because this is an immediate dialog.
> Q3: Does performing a Full database backup through Enterprise manager
> automatically remove the inactived portion in the log file (or the portion
> has been committed and written to the database)? It is grayed out in both
> Full DB backup and Diff Backup. It is only available in Log backup.
Only transaction log backup empties the transaction log. This is in order for a db backup to not break the log
backup chain sequence.
> Q4: How do you define "inactive entries"?
Transaction log records generated by transactions that are committed, and there is no earlier non-committed
transaction. These are not required for SQL server to perform a possible later rollback for any user.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Frankie" <Frankie@.discussions.microsoft.com> wrote in message
news:9FCB61BB-9A54-4FD9-B948-5229E9F7742E@.microsoft.com...
> Q1: When using All Tasks\Maintenance Plan to setup a database backup, why
> does it have options for differential backup?
> Q2: When using All Tasks\Backup Database, Why don't I have option
> Remove the files older than
> Q3: Does performing a Full database backup through Enterprise manager
> automatically remove the inactived portion in the log file (or the portion
> has been committed and written to the database)? It is grayed out in both
> Full DB backup and Diff Backup. It is only available in Log backup.
> Q4: How do you define "inactive entries"?
> Thanks
Monday, February 20, 2012
Q: TRN backup files
Hello,
In my backup maintenance, I have set deletion of backup files after 3 days,
it works for complete backup but not for transaction backup. (I see *.BAK are
removed, *.TRN are still there) what is problem?
Thanks,
Jim.Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> Hello,
> In my backup maintenance, I have set deletion of backup files after 3 days,
> it works for complete backup but not for transaction backup. (I see *.BAK are
> removed, *.TRN are still there) what is problem?
> Thanks,
> Jim.
>|||where can I check if it is in recovery mode?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||yes you were right, the database is in full mode, other databases are in
simple mode, what is difference? If simple mode, is it not recoverable? I do
not see any TRN files if the database is in simple mode, is this a problem?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||mmm. I was reading it, I guess I need to keep it in full mode, but how far
does this TRN file go, is there a limit, or can we create a limit?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||This is a too big topic for a newsgroup conversation. I suggest you read in Books Online about how
backup and restore work in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:2734BEE1-0312-45BE-B1F2-5EEFD6450A69@.microsoft.com...
> yes you were right, the database is in full mode, other databases are in
> simple mode, what is difference? If simple mode, is it not recoverable? I do
> not see any TRN files if the database is in simple mode, is this a problem?
> "Tibor Karaszi" wrote:
>> Perhaps the plan involves trying to do log backup for databases which are in simple recovery
>> mode?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
>> > Hello,
>> > In my backup maintenance, I have set deletion of backup files after 3 days,
>> > it works for complete backup but not for transaction backup. (I see *.BAK are
>> > removed, *.TRN are still there) what is problem?
>> > Thanks,
>> > Jim.
>> >
>>
In my backup maintenance, I have set deletion of backup files after 3 days,
it works for complete backup but not for transaction backup. (I see *.BAK are
removed, *.TRN are still there) what is problem?
Thanks,
Jim.Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> Hello,
> In my backup maintenance, I have set deletion of backup files after 3 days,
> it works for complete backup but not for transaction backup. (I see *.BAK are
> removed, *.TRN are still there) what is problem?
> Thanks,
> Jim.
>|||where can I check if it is in recovery mode?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||yes you were right, the database is in full mode, other databases are in
simple mode, what is difference? If simple mode, is it not recoverable? I do
not see any TRN files if the database is in simple mode, is this a problem?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||mmm. I was reading it, I guess I need to keep it in full mode, but how far
does this TRN file go, is there a limit, or can we create a limit?
"Tibor Karaszi" wrote:
> Perhaps the plan involves trying to do log backup for databases which are in simple recovery mode?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
> > Hello,
> > In my backup maintenance, I have set deletion of backup files after 3 days,
> > it works for complete backup but not for transaction backup. (I see *.BAK are
> > removed, *.TRN are still there) what is problem?
> > Thanks,
> > Jim.
> >
>
>|||This is a too big topic for a newsgroup conversation. I suggest you read in Books Online about how
backup and restore work in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:2734BEE1-0312-45BE-B1F2-5EEFD6450A69@.microsoft.com...
> yes you were right, the database is in full mode, other databases are in
> simple mode, what is difference? If simple mode, is it not recoverable? I do
> not see any TRN files if the database is in simple mode, is this a problem?
> "Tibor Karaszi" wrote:
>> Perhaps the plan involves trying to do log backup for databases which are in simple recovery
>> mode?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:E03BBDB2-3ACF-4656-9BDE-1BB596DA74D9@.microsoft.com...
>> > Hello,
>> > In my backup maintenance, I have set deletion of backup files after 3 days,
>> > it works for complete backup but not for transaction backup. (I see *.BAK are
>> > removed, *.TRN are still there) what is problem?
>> > Thanks,
>> > Jim.
>> >
>>
Subscribe to:
Posts (Atom)