For SQL2000 - Just wondering if the incremental backup requires transaction
logs.
We have a database upgrade process that performs a lot of updates. In order
to keep the transaction log from growing out of control - I would like to be
able to set the recovery model as "simple". I am hoping that I could do the
following:
1. Perform a full DB backup
2. Set the recovery model to Simple
3. Run the upgrade
4. Set the recovery model back to Full
5. Run an incremental backup
Does this sound reasonable? Should steps 4 and 5 be reversed?
Thanks in advance.
No, Incremental backups (which are called transaction log backups in SQL server) are based on the
transaction log. If you are missing log records in the transaction log, you wouldn't be able to
restore from the transaction log backups.
Consider differential backups, perhaps?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJT" <TJT@.nospam.com> wrote in message news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> For SQL2000 - Just wondering if the incremental backup requires transaction
> logs.
> We have a database upgrade process that performs a lot of updates. In order
> to keep the transaction log from growing out of control - I would like to be
> able to set the recovery model as "simple". I am hoping that I could do the
> following:
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run an incremental backup
> Does this sound reasonable? Should steps 4 and 5 be reversed?
> Thanks in advance.
>
|||"TJT" <TJT@.nospam.com> wrote in message
news:OWT5nJ#eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> For SQL2000 - Just wondering if the incremental backup requires
transaction
> logs.
> We have a database upgrade process that performs a lot of updates. In
order
> to keep the transaction log from growing out of control - I would like to
be
> able to set the recovery model as "simple". I am hoping that I could do
the
> following:
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run an incremental backup
> Does this sound reasonable? Should steps 4 and 5 be reversed?
> Thanks in advance.
>
If this is a one-time upgrade, I would suggest the following...
1. Perform Full DB Backup
2. Set to Simple
3. Run upgrade
4. Perform Full DB Backup
5. Test your upgraded information. If all is OK
6. Set recovery back to full.
I'm not sure why you need the incrementals.
Rick Sawtell
MCT, MCSD, MCDBA
|||Hi Tibor,
Actually - I really meant to ask the question about Differential backups
(and not Incremental). I just had my terminology messed up.
So - would I be able to do this for Differential backups...
1. Perform a full DB backup
2. Set the recovery model to Simple
3. Run the upgrade
4. Set the recovery model back to Full
5. Run a differential backup
Thanks!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u4zfMN%23eFHA.3012@.tk2msftngp13.phx.gbl...
> No, Incremental backups (which are called transaction log backups in SQL
server) are based on the
> transaction log. If you are missing log records in the transaction log,
you wouldn't be able to
> restore from the transaction log backups.
> Consider differential backups, perhaps?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TJT" <TJT@.nospam.com> wrote in message
news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
transaction[vbcol=seagreen]
order[vbcol=seagreen]
to be[vbcol=seagreen]
the
>
|||Hi Rick,
The database is rather large (90GB) and we are trying to minimize downtime.
This is why I was hoping to perform a differential backup.
If the database were small and downtime were not a problem - I would perform
another Full backup after the upgrade as you suggest.
Thanks,
Tom
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:uvuhVO%23eFHA.1448@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> "TJT" <TJT@.nospam.com> wrote in message
> news:OWT5nJ#eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> transaction
> order
to
> be
> the
> If this is a one-time upgrade, I would suggest the following...
> 1. Perform Full DB Backup
> 2. Set to Simple
> 3. Run upgrade
> 4. Perform Full DB Backup
> 5. Test your upgraded information. If all is OK
> 6. Set recovery back to full.
>
> I'm not sure why you need the incrementals.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Yes, that should work. Just test on a test server that the steps are fine first (possibly with less
data volume). Also, be aware that you have now broken your chains of log backups. The log backup
taken after this will not be able to apply after a log backup taken before all this. Only from the
last db backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJT" <TJT@.nospam.com> wrote in message news:eySKSR%23eFHA.2244@.TK2MSFTNGP15.phx.gbl...
> Hi Tibor,
> Actually - I really meant to ask the question about Differential backups
> (and not Incremental). I just had my terminology messed up.
> So - would I be able to do this for Differential backups...
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run a differential backup
> Thanks!
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:u4zfMN%23eFHA.3012@.tk2msftngp13.phx.gbl...
> server) are based on the
> you wouldn't be able to
> news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> transaction
> order
> to be
> the
>
|||I can backup 90GB in just a few minutes using no third party tools
How long is "Too Long" ?
What kind of IO subSystem do you have ? (RAID Array, SAN, NAS)
Greg Jackson
PDX, Oregon
Showing posts with label performs. Show all posts
Showing posts with label performs. Show all posts
Sunday, March 11, 2012
Can Incremental Backup be done with Simple recovery Model?
For SQL2000 - Just wondering if the incremental backup requires transaction
logs.
We have a database upgrade process that performs a lot of updates. In order
to keep the transaction log from growing out of control - I would like to be
able to set the recovery model as "simple". I am hoping that I could do the
following:
1. Perform a full DB backup
2. Set the recovery model to Simple
3. Run the upgrade
4. Set the recovery model back to Full
5. Run an incremental backup
Does this sound reasonable? Should steps 4 and 5 be reversed?
Thanks in advance.No, Incremental backups (which are called transaction log backups in SQL ser
ver) are based on the
transaction log. If you are missing log records in the transaction log, you
wouldn't be able to
restore from the transaction log backups.
Consider differential backups, perhaps?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJT" <TJT@.nospam.com> wrote in message news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...[vbco
l=seagreen]
> For SQL2000 - Just wondering if the incremental backup requires transactio
n
> logs.
> We have a database upgrade process that performs a lot of updates. In ord
er
> to keep the transaction log from growing out of control - I would like to
be
> able to set the recovery model as "simple". I am hoping that I could do t
he
> following:
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run an incremental backup
> Does this sound reasonable? Should steps 4 and 5 be reversed?
> Thanks in advance.
>[/vbcol]|||"TJT" <TJT@.nospam.com> wrote in message
news:OWT5nJ#eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> For SQL2000 - Just wondering if the incremental backup requires
transaction
> logs.
> We have a database upgrade process that performs a lot of updates. In
order
> to keep the transaction log from growing out of control - I would like to
be
> able to set the recovery model as "simple". I am hoping that I could do
the
> following:
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run an incremental backup
> Does this sound reasonable? Should steps 4 and 5 be reversed?
> Thanks in advance.
>
If this is a one-time upgrade, I would suggest the following...
1. Perform Full DB Backup
2. Set to Simple
3. Run upgrade
4. Perform Full DB Backup
5. Test your upgraded information. If all is OK
6. Set recovery back to full.
I'm not sure why you need the incrementals.
Rick Sawtell
MCT, MCSD, MCDBA|||Hi Tibor,
Actually - I really meant to ask the question about Differential backups
(and not Incremental). I just had my terminology messed up.
So - would I be able to do this for Differential backups...
1. Perform a full DB backup
2. Set the recovery model to Simple
3. Run the upgrade
4. Set the recovery model back to Full
5. Run a differential backup
Thanks!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u4zfMN%23eFHA.3012@.tk2msftngp13.phx.gbl...
> No, Incremental backups (which are called transaction log backups in SQL
server) are based on the
> transaction log. If you are missing log records in the transaction log,
you wouldn't be able to
> restore from the transaction log backups.
> Consider differential backups, perhaps?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TJT" <TJT@.nospam.com> wrote in message
news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
transaction[vbcol=seagreen]
order[vbcol=seagreen]
to be[vbcol=seagreen]
the[vbcol=seagreen]
>|||Hi Rick,
The database is rather large (90GB) and we are trying to minimize downtime.
This is why I was hoping to perform a differential backup.
If the database were small and downtime were not a problem - I would perform
another Full backup after the upgrade as you suggest.
Thanks,
Tom
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:uvuhVO%23eFHA.1448@.TK2MSFTNGP14.phx.gbl...
> "TJT" <TJT@.nospam.com> wrote in message
> news:OWT5nJ#eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> transaction
> order
to[vbcol=seagreen]
> be
> the
> If this is a one-time upgrade, I would suggest the following...
> 1. Perform Full DB Backup
> 2. Set to Simple
> 3. Run upgrade
> 4. Perform Full DB Backup
> 5. Test your upgraded information. If all is OK
> 6. Set recovery back to full.
>
> I'm not sure why you need the incrementals.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Yes, that should work. Just test on a test server that the steps are fine fi
rst (possibly with less
data volume). Also, be aware that you have now broken your chains of log bac
kups. The log backup
taken after this will not be able to apply after a log backup taken before a
ll this. Only from the
last db backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJT" <TJT@.nospam.com> wrote in message news:eySKSR%23eFHA.2244@.TK2MSFTNGP15.phx.gbl...[vbco
l=seagreen]
> Hi Tibor,
> Actually - I really meant to ask the question about Differential backups
> (and not Incremental). I just had my terminology messed up.
> So - would I be able to do this for Differential backups...
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run a differential backup
> Thanks!
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:u4zfMN%23eFHA.3012@.tk2msftngp13.phx.gbl...
> server) are based on the
> you wouldn't be able to
> news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> transaction
> order
> to be
> the
>[/vbcol]|||I can backup 90GB in just a few minutes using no third party tools
How long is "Too Long" ?
What kind of IO subSystem do you have ? (RAID Array, SAN, NAS)
Greg Jackson
PDX, Oregon
logs.
We have a database upgrade process that performs a lot of updates. In order
to keep the transaction log from growing out of control - I would like to be
able to set the recovery model as "simple". I am hoping that I could do the
following:
1. Perform a full DB backup
2. Set the recovery model to Simple
3. Run the upgrade
4. Set the recovery model back to Full
5. Run an incremental backup
Does this sound reasonable? Should steps 4 and 5 be reversed?
Thanks in advance.No, Incremental backups (which are called transaction log backups in SQL ser
ver) are based on the
transaction log. If you are missing log records in the transaction log, you
wouldn't be able to
restore from the transaction log backups.
Consider differential backups, perhaps?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJT" <TJT@.nospam.com> wrote in message news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...[vbco
l=seagreen]
> For SQL2000 - Just wondering if the incremental backup requires transactio
n
> logs.
> We have a database upgrade process that performs a lot of updates. In ord
er
> to keep the transaction log from growing out of control - I would like to
be
> able to set the recovery model as "simple". I am hoping that I could do t
he
> following:
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run an incremental backup
> Does this sound reasonable? Should steps 4 and 5 be reversed?
> Thanks in advance.
>[/vbcol]|||"TJT" <TJT@.nospam.com> wrote in message
news:OWT5nJ#eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> For SQL2000 - Just wondering if the incremental backup requires
transaction
> logs.
> We have a database upgrade process that performs a lot of updates. In
order
> to keep the transaction log from growing out of control - I would like to
be
> able to set the recovery model as "simple". I am hoping that I could do
the
> following:
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run an incremental backup
> Does this sound reasonable? Should steps 4 and 5 be reversed?
> Thanks in advance.
>
If this is a one-time upgrade, I would suggest the following...
1. Perform Full DB Backup
2. Set to Simple
3. Run upgrade
4. Perform Full DB Backup
5. Test your upgraded information. If all is OK
6. Set recovery back to full.
I'm not sure why you need the incrementals.
Rick Sawtell
MCT, MCSD, MCDBA|||Hi Tibor,
Actually - I really meant to ask the question about Differential backups
(and not Incremental). I just had my terminology messed up.
So - would I be able to do this for Differential backups...
1. Perform a full DB backup
2. Set the recovery model to Simple
3. Run the upgrade
4. Set the recovery model back to Full
5. Run a differential backup
Thanks!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u4zfMN%23eFHA.3012@.tk2msftngp13.phx.gbl...
> No, Incremental backups (which are called transaction log backups in SQL
server) are based on the
> transaction log. If you are missing log records in the transaction log,
you wouldn't be able to
> restore from the transaction log backups.
> Consider differential backups, perhaps?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TJT" <TJT@.nospam.com> wrote in message
news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
transaction[vbcol=seagreen]
order[vbcol=seagreen]
to be[vbcol=seagreen]
the[vbcol=seagreen]
>|||Hi Rick,
The database is rather large (90GB) and we are trying to minimize downtime.
This is why I was hoping to perform a differential backup.
If the database were small and downtime were not a problem - I would perform
another Full backup after the upgrade as you suggest.
Thanks,
Tom
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:uvuhVO%23eFHA.1448@.TK2MSFTNGP14.phx.gbl...
> "TJT" <TJT@.nospam.com> wrote in message
> news:OWT5nJ#eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> transaction
> order
to[vbcol=seagreen]
> be
> the
> If this is a one-time upgrade, I would suggest the following...
> 1. Perform Full DB Backup
> 2. Set to Simple
> 3. Run upgrade
> 4. Perform Full DB Backup
> 5. Test your upgraded information. If all is OK
> 6. Set recovery back to full.
>
> I'm not sure why you need the incrementals.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Yes, that should work. Just test on a test server that the steps are fine fi
rst (possibly with less
data volume). Also, be aware that you have now broken your chains of log bac
kups. The log backup
taken after this will not be able to apply after a log backup taken before a
ll this. Only from the
last db backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJT" <TJT@.nospam.com> wrote in message news:eySKSR%23eFHA.2244@.TK2MSFTNGP15.phx.gbl...[vbco
l=seagreen]
> Hi Tibor,
> Actually - I really meant to ask the question about Differential backups
> (and not Incremental). I just had my terminology messed up.
> So - would I be able to do this for Differential backups...
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run a differential backup
> Thanks!
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:u4zfMN%23eFHA.3012@.tk2msftngp13.phx.gbl...
> server) are based on the
> you wouldn't be able to
> news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> transaction
> order
> to be
> the
>[/vbcol]|||I can backup 90GB in just a few minutes using no third party tools
How long is "Too Long" ?
What kind of IO subSystem do you have ? (RAID Array, SAN, NAS)
Greg Jackson
PDX, Oregon
Can Incremental Backup be done with Simple recovery Model?
For SQL2000 - Just wondering if the incremental backup requires transaction
logs.
We have a database upgrade process that performs a lot of updates. In order
to keep the transaction log from growing out of control - I would like to be
able to set the recovery model as "simple". I am hoping that I could do the
following:
1. Perform a full DB backup
2. Set the recovery model to Simple
3. Run the upgrade
4. Set the recovery model back to Full
5. Run an incremental backup
Does this sound reasonable? Should steps 4 and 5 be reversed?
Thanks in advance.No, Incremental backups (which are called transaction log backups in SQL server) are based on the
transaction log. If you are missing log records in the transaction log, you wouldn't be able to
restore from the transaction log backups.
Consider differential backups, perhaps?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJT" <TJT@.nospam.com> wrote in message news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> For SQL2000 - Just wondering if the incremental backup requires transaction
> logs.
> We have a database upgrade process that performs a lot of updates. In order
> to keep the transaction log from growing out of control - I would like to be
> able to set the recovery model as "simple". I am hoping that I could do the
> following:
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run an incremental backup
> Does this sound reasonable? Should steps 4 and 5 be reversed?
> Thanks in advance.
>|||"TJT" <TJT@.nospam.com> wrote in message
news:OWT5nJ#eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> For SQL2000 - Just wondering if the incremental backup requires
transaction
> logs.
> We have a database upgrade process that performs a lot of updates. In
order
> to keep the transaction log from growing out of control - I would like to
be
> able to set the recovery model as "simple". I am hoping that I could do
the
> following:
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run an incremental backup
> Does this sound reasonable? Should steps 4 and 5 be reversed?
> Thanks in advance.
>
If this is a one-time upgrade, I would suggest the following...
1. Perform Full DB Backup
2. Set to Simple
3. Run upgrade
4. Perform Full DB Backup
5. Test your upgraded information. If all is OK
6. Set recovery back to full.
I'm not sure why you need the incrementals.
Rick Sawtell
MCT, MCSD, MCDBA|||Hi Tibor,
Actually - I really meant to ask the question about Differential backups
(and not Incremental). I just had my terminology messed up.
So - would I be able to do this for Differential backups...
1. Perform a full DB backup
2. Set the recovery model to Simple
3. Run the upgrade
4. Set the recovery model back to Full
5. Run a differential backup
Thanks!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u4zfMN%23eFHA.3012@.tk2msftngp13.phx.gbl...
> No, Incremental backups (which are called transaction log backups in SQL
server) are based on the
> transaction log. If you are missing log records in the transaction log,
you wouldn't be able to
> restore from the transaction log backups.
> Consider differential backups, perhaps?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TJT" <TJT@.nospam.com> wrote in message
news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> > For SQL2000 - Just wondering if the incremental backup requires
transaction
> > logs.
> >
> > We have a database upgrade process that performs a lot of updates. In
order
> > to keep the transaction log from growing out of control - I would like
to be
> > able to set the recovery model as "simple". I am hoping that I could do
the
> > following:
> > 1. Perform a full DB backup
> > 2. Set the recovery model to Simple
> > 3. Run the upgrade
> > 4. Set the recovery model back to Full
> > 5. Run an incremental backup
> >
> > Does this sound reasonable? Should steps 4 and 5 be reversed?
> >
> > Thanks in advance.
> >
> >
>|||Hi Rick,
The database is rather large (90GB) and we are trying to minimize downtime.
This is why I was hoping to perform a differential backup.
If the database were small and downtime were not a problem - I would perform
another Full backup after the upgrade as you suggest.
Thanks,
Tom
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:uvuhVO%23eFHA.1448@.TK2MSFTNGP14.phx.gbl...
> "TJT" <TJT@.nospam.com> wrote in message
> news:OWT5nJ#eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> > For SQL2000 - Just wondering if the incremental backup requires
> transaction
> > logs.
> >
> > We have a database upgrade process that performs a lot of updates. In
> order
> > to keep the transaction log from growing out of control - I would like
to
> be
> > able to set the recovery model as "simple". I am hoping that I could do
> the
> > following:
> > 1. Perform a full DB backup
> > 2. Set the recovery model to Simple
> > 3. Run the upgrade
> > 4. Set the recovery model back to Full
> > 5. Run an incremental backup
> >
> > Does this sound reasonable? Should steps 4 and 5 be reversed?
> >
> > Thanks in advance.
> >
> >
> If this is a one-time upgrade, I would suggest the following...
> 1. Perform Full DB Backup
> 2. Set to Simple
> 3. Run upgrade
> 4. Perform Full DB Backup
> 5. Test your upgraded information. If all is OK
> 6. Set recovery back to full.
>
> I'm not sure why you need the incrementals.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Yes, that should work. Just test on a test server that the steps are fine first (possibly with less
data volume). Also, be aware that you have now broken your chains of log backups. The log backup
taken after this will not be able to apply after a log backup taken before all this. Only from the
last db backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJT" <TJT@.nospam.com> wrote in message news:eySKSR%23eFHA.2244@.TK2MSFTNGP15.phx.gbl...
> Hi Tibor,
> Actually - I really meant to ask the question about Differential backups
> (and not Incremental). I just had my terminology messed up.
> So - would I be able to do this for Differential backups...
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run a differential backup
> Thanks!
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:u4zfMN%23eFHA.3012@.tk2msftngp13.phx.gbl...
>> No, Incremental backups (which are called transaction log backups in SQL
> server) are based on the
>> transaction log. If you are missing log records in the transaction log,
> you wouldn't be able to
>> restore from the transaction log backups.
>> Consider differential backups, perhaps?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "TJT" <TJT@.nospam.com> wrote in message
> news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> > For SQL2000 - Just wondering if the incremental backup requires
> transaction
>> > logs.
>> >
>> > We have a database upgrade process that performs a lot of updates. In
> order
>> > to keep the transaction log from growing out of control - I would like
> to be
>> > able to set the recovery model as "simple". I am hoping that I could do
> the
>> > following:
>> > 1. Perform a full DB backup
>> > 2. Set the recovery model to Simple
>> > 3. Run the upgrade
>> > 4. Set the recovery model back to Full
>> > 5. Run an incremental backup
>> >
>> > Does this sound reasonable? Should steps 4 and 5 be reversed?
>> >
>> > Thanks in advance.
>> >
>> >
>>
>|||I can backup 90GB in just a few minutes using no third party tools
How long is "Too Long" ?
What kind of IO subSystem do you have ? (RAID Array, SAN, NAS)
Greg Jackson
PDX, Oregon
logs.
We have a database upgrade process that performs a lot of updates. In order
to keep the transaction log from growing out of control - I would like to be
able to set the recovery model as "simple". I am hoping that I could do the
following:
1. Perform a full DB backup
2. Set the recovery model to Simple
3. Run the upgrade
4. Set the recovery model back to Full
5. Run an incremental backup
Does this sound reasonable? Should steps 4 and 5 be reversed?
Thanks in advance.No, Incremental backups (which are called transaction log backups in SQL server) are based on the
transaction log. If you are missing log records in the transaction log, you wouldn't be able to
restore from the transaction log backups.
Consider differential backups, perhaps?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJT" <TJT@.nospam.com> wrote in message news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> For SQL2000 - Just wondering if the incremental backup requires transaction
> logs.
> We have a database upgrade process that performs a lot of updates. In order
> to keep the transaction log from growing out of control - I would like to be
> able to set the recovery model as "simple". I am hoping that I could do the
> following:
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run an incremental backup
> Does this sound reasonable? Should steps 4 and 5 be reversed?
> Thanks in advance.
>|||"TJT" <TJT@.nospam.com> wrote in message
news:OWT5nJ#eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> For SQL2000 - Just wondering if the incremental backup requires
transaction
> logs.
> We have a database upgrade process that performs a lot of updates. In
order
> to keep the transaction log from growing out of control - I would like to
be
> able to set the recovery model as "simple". I am hoping that I could do
the
> following:
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run an incremental backup
> Does this sound reasonable? Should steps 4 and 5 be reversed?
> Thanks in advance.
>
If this is a one-time upgrade, I would suggest the following...
1. Perform Full DB Backup
2. Set to Simple
3. Run upgrade
4. Perform Full DB Backup
5. Test your upgraded information. If all is OK
6. Set recovery back to full.
I'm not sure why you need the incrementals.
Rick Sawtell
MCT, MCSD, MCDBA|||Hi Tibor,
Actually - I really meant to ask the question about Differential backups
(and not Incremental). I just had my terminology messed up.
So - would I be able to do this for Differential backups...
1. Perform a full DB backup
2. Set the recovery model to Simple
3. Run the upgrade
4. Set the recovery model back to Full
5. Run a differential backup
Thanks!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u4zfMN%23eFHA.3012@.tk2msftngp13.phx.gbl...
> No, Incremental backups (which are called transaction log backups in SQL
server) are based on the
> transaction log. If you are missing log records in the transaction log,
you wouldn't be able to
> restore from the transaction log backups.
> Consider differential backups, perhaps?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TJT" <TJT@.nospam.com> wrote in message
news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> > For SQL2000 - Just wondering if the incremental backup requires
transaction
> > logs.
> >
> > We have a database upgrade process that performs a lot of updates. In
order
> > to keep the transaction log from growing out of control - I would like
to be
> > able to set the recovery model as "simple". I am hoping that I could do
the
> > following:
> > 1. Perform a full DB backup
> > 2. Set the recovery model to Simple
> > 3. Run the upgrade
> > 4. Set the recovery model back to Full
> > 5. Run an incremental backup
> >
> > Does this sound reasonable? Should steps 4 and 5 be reversed?
> >
> > Thanks in advance.
> >
> >
>|||Hi Rick,
The database is rather large (90GB) and we are trying to minimize downtime.
This is why I was hoping to perform a differential backup.
If the database were small and downtime were not a problem - I would perform
another Full backup after the upgrade as you suggest.
Thanks,
Tom
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:uvuhVO%23eFHA.1448@.TK2MSFTNGP14.phx.gbl...
> "TJT" <TJT@.nospam.com> wrote in message
> news:OWT5nJ#eFHA.3808@.TK2MSFTNGP14.phx.gbl...
> > For SQL2000 - Just wondering if the incremental backup requires
> transaction
> > logs.
> >
> > We have a database upgrade process that performs a lot of updates. In
> order
> > to keep the transaction log from growing out of control - I would like
to
> be
> > able to set the recovery model as "simple". I am hoping that I could do
> the
> > following:
> > 1. Perform a full DB backup
> > 2. Set the recovery model to Simple
> > 3. Run the upgrade
> > 4. Set the recovery model back to Full
> > 5. Run an incremental backup
> >
> > Does this sound reasonable? Should steps 4 and 5 be reversed?
> >
> > Thanks in advance.
> >
> >
> If this is a one-time upgrade, I would suggest the following...
> 1. Perform Full DB Backup
> 2. Set to Simple
> 3. Run upgrade
> 4. Perform Full DB Backup
> 5. Test your upgraded information. If all is OK
> 6. Set recovery back to full.
>
> I'm not sure why you need the incrementals.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Yes, that should work. Just test on a test server that the steps are fine first (possibly with less
data volume). Also, be aware that you have now broken your chains of log backups. The log backup
taken after this will not be able to apply after a log backup taken before all this. Only from the
last db backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJT" <TJT@.nospam.com> wrote in message news:eySKSR%23eFHA.2244@.TK2MSFTNGP15.phx.gbl...
> Hi Tibor,
> Actually - I really meant to ask the question about Differential backups
> (and not Incremental). I just had my terminology messed up.
> So - would I be able to do this for Differential backups...
> 1. Perform a full DB backup
> 2. Set the recovery model to Simple
> 3. Run the upgrade
> 4. Set the recovery model back to Full
> 5. Run a differential backup
> Thanks!
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:u4zfMN%23eFHA.3012@.tk2msftngp13.phx.gbl...
>> No, Incremental backups (which are called transaction log backups in SQL
> server) are based on the
>> transaction log. If you are missing log records in the transaction log,
> you wouldn't be able to
>> restore from the transaction log backups.
>> Consider differential backups, perhaps?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "TJT" <TJT@.nospam.com> wrote in message
> news:OWT5nJ%23eFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> > For SQL2000 - Just wondering if the incremental backup requires
> transaction
>> > logs.
>> >
>> > We have a database upgrade process that performs a lot of updates. In
> order
>> > to keep the transaction log from growing out of control - I would like
> to be
>> > able to set the recovery model as "simple". I am hoping that I could do
> the
>> > following:
>> > 1. Perform a full DB backup
>> > 2. Set the recovery model to Simple
>> > 3. Run the upgrade
>> > 4. Set the recovery model back to Full
>> > 5. Run an incremental backup
>> >
>> > Does this sound reasonable? Should steps 4 and 5 be reversed?
>> >
>> > Thanks in advance.
>> >
>> >
>>
>|||I can backup 90GB in just a few minutes using no third party tools
How long is "Too Long" ?
What kind of IO subSystem do you have ? (RAID Array, SAN, NAS)
Greg Jackson
PDX, Oregon
Tuesday, February 14, 2012
Can I purchase off-the-shelf xps? (e.g., encrypt/decrypt function
Can anyone tell me if there is a market for extended stored procedures?
We are looking for an xp that performs a simple encrypt/decrypt function
that complies with the Advanced Encryption Standard (AES). For example, you
pass it a value and it encrypts or decrypts the value.
Are there third party xps available? And if so, where might I find these xps?
Thanks
Dave
Here's one:
http://www.activecrypt.com/
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave
|||http://www.xpcrypt.com/
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave
|||If you can wait for the release of SQL2005 this is built in to the product.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave
We are looking for an xp that performs a simple encrypt/decrypt function
that complies with the Advanced Encryption Standard (AES). For example, you
pass it a value and it encrypts or decrypts the value.
Are there third party xps available? And if so, where might I find these xps?
Thanks
Dave
Here's one:
http://www.activecrypt.com/
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave
|||http://www.xpcrypt.com/
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave
|||If you can wait for the release of SQL2005 this is built in to the product.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave
Can I purchase off-the-shelf xps? (e.g., encrypt/decrypt function
Can anyone tell me if there is a market for extended stored procedures?
We are looking for an xp that performs a simple encrypt/decrypt function
that complies with the Advanced Encryption Standard (AES). For example, you
pass it a value and it encrypts or decrypts the value.
Are there third party xps available? And if so, where might I find these xps?
Thanks
DaveHere's one:
http://www.activecrypt.com/
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave|||http://www.xpcrypt.com/
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave|||If you can wait for the release of SQL2005 this is built in to the product.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave|||I am looking at xp_crypt which I believe is the same as activecrypt.
This a full blown solution that automativcally creates views, triggers, etc.
to support the encryption function.
I was wondering if there might be a scalled down encryption solution; just a
dll that performs encrypt/decrypt and could be registered as an extended
stored procedure in SQL Server.
Does anyone know if something like this is available?
"Mike Epprecht (SQL MVP)" wrote:
> http://www.xpcrypt.com/
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Dave" <Dave@.discussions.microsoft.com> wrote in message
> news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> > Can anyone tell me if there is a market for extended stored procedures?
> >
> > We are looking for an xp that performs a simple encrypt/decrypt function
> > that complies with the Advanced Encryption Standard (AES). For example,
> > you
> > pass it a value and it encrypts or decrypts the value.
> >
> > Are there third party xps available? And if so, where might I find these
> > xps?
> >
> > Thanks
> > Dave
>
>
We are looking for an xp that performs a simple encrypt/decrypt function
that complies with the Advanced Encryption Standard (AES). For example, you
pass it a value and it encrypts or decrypts the value.
Are there third party xps available? And if so, where might I find these xps?
Thanks
DaveHere's one:
http://www.activecrypt.com/
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave|||http://www.xpcrypt.com/
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave|||If you can wait for the release of SQL2005 this is built in to the product.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave|||I am looking at xp_crypt which I believe is the same as activecrypt.
This a full blown solution that automativcally creates views, triggers, etc.
to support the encryption function.
I was wondering if there might be a scalled down encryption solution; just a
dll that performs encrypt/decrypt and could be registered as an extended
stored procedure in SQL Server.
Does anyone know if something like this is available?
"Mike Epprecht (SQL MVP)" wrote:
> http://www.xpcrypt.com/
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Dave" <Dave@.discussions.microsoft.com> wrote in message
> news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> > Can anyone tell me if there is a market for extended stored procedures?
> >
> > We are looking for an xp that performs a simple encrypt/decrypt function
> > that complies with the Advanced Encryption Standard (AES). For example,
> > you
> > pass it a value and it encrypts or decrypts the value.
> >
> > Are there third party xps available? And if so, where might I find these
> > xps?
> >
> > Thanks
> > Dave
>
>
Can I purchase off-the-shelf xps? (e.g., encrypt/decrypt function
Can anyone tell me if there is a market for extended stored procedures?
We are looking for an xp that performs a simple encrypt/decrypt function
that complies with the Advanced Encryption Standard (AES). For example, you
pass it a value and it encrypts or decrypts the value.
Are there third party xps available? And if so, where might I find these xps
?
Thanks
DaveHere's one:
http://www.activecrypt.com/
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave|||http://www.xpcrypt.com/
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave|||If you can wait for the release of SQL2005 this is built in to the product.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave
We are looking for an xp that performs a simple encrypt/decrypt function
that complies with the Advanced Encryption Standard (AES). For example, you
pass it a value and it encrypts or decrypts the value.
Are there third party xps available? And if so, where might I find these xps
?
Thanks
DaveHere's one:
http://www.activecrypt.com/
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave|||http://www.xpcrypt.com/
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave|||If you can wait for the release of SQL2005 this is built in to the product.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:76DCE302-380F-4646-AD41-54C8CB7A569D@.microsoft.com...
> Can anyone tell me if there is a market for extended stored procedures?
> We are looking for an xp that performs a simple encrypt/decrypt function
> that complies with the Advanced Encryption Standard (AES). For example,
> you
> pass it a value and it encrypts or decrypts the value.
> Are there third party xps available? And if so, where might I find these
> xps?
> Thanks
> Dave
Subscribe to:
Posts (Atom)