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 setup. Show all posts
Showing posts with label setup. 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
Friday, March 9, 2012
QA Setup question
I know that this is just a very small point, but it bugs me and I
wonder if there is a work around. When I use an old version of QA
(version 8.000.194) keywords are properly highlighted. When I run a
more recent version (8.000.760), some are, but some (FROM, WHERE, AND,
etc) are not. Is there a fix for this? Thanks.
-Johntry going to Tools-->Options-->Fonts
Then select keyword in the colors panel and set it to the correct
color, see if that helps
http://sqlservercode.blogspot.com/|||"SQL" <denis.gobo@.gmail.com> wrote:
>try going to Tools-->Options-->Fonts
>Then select keyword in the colors panel and set it to the correct
>color, see if that helps
>
That's exactly what I'm doing and I'm not getting the color change on
come keywords.
-John|||Can you try clicking "reset all".
"John Baima" <john@.nospam.com> wrote in message
news:gltns1dcib24om49o5m32jmme5m7jje3c9@.
4ax.com...
> "SQL" <denis.gobo@.gmail.com> wrote:
>
> That's exactly what I'm doing and I'm not getting the color change on
> come keywords.
> -John
>|||"Raymond D'Anjou" <rdanjou@.canatradeNOSPAM.com> wrote:
>Can you try clicking "reset all".
>"John Baima" <john@.nospam.com> wrote in message
> news:gltns1dcib24om49o5m32jmme5m7jje3c9@.
4ax.com...
No, that does not change anything. Again, some keywords are
highlighted, but not all. The versions are different. What is the
latest and greatest version number for QA'
-John|||John Baima (john@.nospam.com) writes:
> I know that this is just a very small point, but it bugs me and I
> wonder if there is a work around. When I use an old version of QA
> (version 8.000.194) keywords are properly highlighted. When I run a
> more recent version (8.000.760), some are, but some (FROM, WHERE, AND,
> etc) are not. Is there a fix for this? Thanks.
In another case I heard of this, no words were highlighted. The suggestion
then was to run
regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqllex.dll"
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog <esquel@.sommarskog.se> wrote:
>John Baima (john@.nospam.com) writes:
>In another case I heard of this, no words were highlighted. The suggestion
>then was to run
> regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqllex.dll"
That was a little scary, but it did the trick! Thanks!
-John
wonder if there is a work around. When I use an old version of QA
(version 8.000.194) keywords are properly highlighted. When I run a
more recent version (8.000.760), some are, but some (FROM, WHERE, AND,
etc) are not. Is there a fix for this? Thanks.
-Johntry going to Tools-->Options-->Fonts
Then select keyword in the colors panel and set it to the correct
color, see if that helps
http://sqlservercode.blogspot.com/|||"SQL" <denis.gobo@.gmail.com> wrote:
>try going to Tools-->Options-->Fonts
>Then select keyword in the colors panel and set it to the correct
>color, see if that helps
>
That's exactly what I'm doing and I'm not getting the color change on
come keywords.
-John|||Can you try clicking "reset all".
"John Baima" <john@.nospam.com> wrote in message
news:gltns1dcib24om49o5m32jmme5m7jje3c9@.
4ax.com...
> "SQL" <denis.gobo@.gmail.com> wrote:
>
> That's exactly what I'm doing and I'm not getting the color change on
> come keywords.
> -John
>|||"Raymond D'Anjou" <rdanjou@.canatradeNOSPAM.com> wrote:
>Can you try clicking "reset all".
>"John Baima" <john@.nospam.com> wrote in message
> news:gltns1dcib24om49o5m32jmme5m7jje3c9@.
4ax.com...
No, that does not change anything. Again, some keywords are
highlighted, but not all. The versions are different. What is the
latest and greatest version number for QA'
-John|||John Baima (john@.nospam.com) writes:
> I know that this is just a very small point, but it bugs me and I
> wonder if there is a work around. When I use an old version of QA
> (version 8.000.194) keywords are properly highlighted. When I run a
> more recent version (8.000.760), some are, but some (FROM, WHERE, AND,
> etc) are not. Is there a fix for this? Thanks.
In another case I heard of this, no words were highlighted. The suggestion
then was to run
regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqllex.dll"
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog <esquel@.sommarskog.se> wrote:
>John Baima (john@.nospam.com) writes:
>In another case I heard of this, no words were highlighted. The suggestion
>then was to run
> regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqllex.dll"
That was a little scary, but it did the trick! Thanks!
-John
Subscribe to:
Posts (Atom)