Hi,
I wanted to clarify something about the backup restore process. If have the
following backups -
Day1 - 3 AM - Full backup
Day1 - 9 AM - Log backup
Day1 - 3 PM - Log backup
Day1 - 9 PM - Log backup
Day2 - 3 AM - Full backup
Day2 - 9 AM - Log backup
Day2 - 3 PM - Log backup
Day2 - 9 PM - Log backup
I want to restore the database to a point in time of 9 PM on Day2. The Full
backup of Day2 is corrupt. Can I restore the database by applying the
following backups in sequence -
Day1 - 3 AM - Full backup - not recovered
Day1 - 9 AM - Log backup - not recovered
Day1 - 3 PM - Log backup - not recovered
Day1 - 9 PM - Log backup - not recovered
Day2 - 9 AM - Log backup - not recovered
Day2 - 3 PM - Log backup - not recovered
Day2 - 9 PM - Log backup - recovered
Thanks in advance.
sharman,
Yes, if none of your log files are corrupt, you can indeed apply them over a
missing full backup, just as you describe. (Thus explaining, for anyone who
wondered, why the full backup does not free up the transaction log.)
RLF
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:CDA7766C-91AB-49E5-85F2-696B1807D59B@.microsoft.com...
> Hi,
> I wanted to clarify something about the backup restore process. If have
> the
> following backups -
> Day1 - 3 AM - Full backup
> Day1 - 9 AM - Log backup
> Day1 - 3 PM - Log backup
> Day1 - 9 PM - Log backup
> Day2 - 3 AM - Full backup
> Day2 - 9 AM - Log backup
> Day2 - 3 PM - Log backup
> Day2 - 9 PM - Log backup
> I want to restore the database to a point in time of 9 PM on Day2. The
> Full
> backup of Day2 is corrupt. Can I restore the database by applying the
> following backups in sequence -
> Day1 - 3 AM - Full backup - not recovered
> Day1 - 9 AM - Log backup - not recovered
> Day1 - 3 PM - Log backup - not recovered
> Day1 - 9 PM - Log backup - not recovered
> Day2 - 9 AM - Log backup - not recovered
> Day2 - 3 PM - Log backup - not recovered
> Day2 - 9 PM - Log backup - recovered
> Thanks in advance.
>
>
Showing posts with label clarify. Show all posts
Showing posts with label clarify. Show all posts
Tuesday, March 20, 2012
backup restore question
Hi,
I wanted to clarify something about the backup restore process. If have the
following backups -
Day1 - 3 AM - Full backup
Day1 - 9 AM - Log backup
Day1 - 3 PM - Log backup
Day1 - 9 PM - Log backup
Day2 - 3 AM - Full backup
Day2 - 9 AM - Log backup
Day2 - 3 PM - Log backup
Day2 - 9 PM - Log backup
I want to restore the database to a point in time of 9 PM on Day2. The Full
backup of Day2 is corrupt. Can I restore the database by applying the
following backups in sequence -
Day1 - 3 AM - Full backup - not recovered
Day1 - 9 AM - Log backup - not recovered
Day1 - 3 PM - Log backup - not recovered
Day1 - 9 PM - Log backup - not recovered
Day2 - 9 AM - Log backup - not recovered
Day2 - 3 PM - Log backup - not recovered
Day2 - 9 PM - Log backup - recovered
Thanks in advance.sharman,
Yes, if none of your log files are corrupt, you can indeed apply them over a
missing full backup, just as you describe. (Thus explaining, for anyone who
wondered, why the full backup does not free up the transaction log.)
RLF
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:CDA7766C-91AB-49E5-85F2-696B1807D59B@.microsoft.com...
> Hi,
> I wanted to clarify something about the backup restore process. If have
> the
> following backups -
> Day1 - 3 AM - Full backup
> Day1 - 9 AM - Log backup
> Day1 - 3 PM - Log backup
> Day1 - 9 PM - Log backup
> Day2 - 3 AM - Full backup
> Day2 - 9 AM - Log backup
> Day2 - 3 PM - Log backup
> Day2 - 9 PM - Log backup
> I want to restore the database to a point in time of 9 PM on Day2. The
> Full
> backup of Day2 is corrupt. Can I restore the database by applying the
> following backups in sequence -
> Day1 - 3 AM - Full backup - not recovered
> Day1 - 9 AM - Log backup - not recovered
> Day1 - 3 PM - Log backup - not recovered
> Day1 - 9 PM - Log backup - not recovered
> Day2 - 9 AM - Log backup - not recovered
> Day2 - 3 PM - Log backup - not recovered
> Day2 - 9 PM - Log backup - recovered
> Thanks in advance.
>
>
I wanted to clarify something about the backup restore process. If have the
following backups -
Day1 - 3 AM - Full backup
Day1 - 9 AM - Log backup
Day1 - 3 PM - Log backup
Day1 - 9 PM - Log backup
Day2 - 3 AM - Full backup
Day2 - 9 AM - Log backup
Day2 - 3 PM - Log backup
Day2 - 9 PM - Log backup
I want to restore the database to a point in time of 9 PM on Day2. The Full
backup of Day2 is corrupt. Can I restore the database by applying the
following backups in sequence -
Day1 - 3 AM - Full backup - not recovered
Day1 - 9 AM - Log backup - not recovered
Day1 - 3 PM - Log backup - not recovered
Day1 - 9 PM - Log backup - not recovered
Day2 - 9 AM - Log backup - not recovered
Day2 - 3 PM - Log backup - not recovered
Day2 - 9 PM - Log backup - recovered
Thanks in advance.sharman,
Yes, if none of your log files are corrupt, you can indeed apply them over a
missing full backup, just as you describe. (Thus explaining, for anyone who
wondered, why the full backup does not free up the transaction log.)
RLF
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:CDA7766C-91AB-49E5-85F2-696B1807D59B@.microsoft.com...
> Hi,
> I wanted to clarify something about the backup restore process. If have
> the
> following backups -
> Day1 - 3 AM - Full backup
> Day1 - 9 AM - Log backup
> Day1 - 3 PM - Log backup
> Day1 - 9 PM - Log backup
> Day2 - 3 AM - Full backup
> Day2 - 9 AM - Log backup
> Day2 - 3 PM - Log backup
> Day2 - 9 PM - Log backup
> I want to restore the database to a point in time of 9 PM on Day2. The
> Full
> backup of Day2 is corrupt. Can I restore the database by applying the
> following backups in sequence -
> Day1 - 3 AM - Full backup - not recovered
> Day1 - 9 AM - Log backup - not recovered
> Day1 - 3 PM - Log backup - not recovered
> Day1 - 9 PM - Log backup - not recovered
> Day2 - 9 AM - Log backup - not recovered
> Day2 - 3 PM - Log backup - not recovered
> Day2 - 9 PM - Log backup - recovered
> Thanks in advance.
>
>
Backup questions
I just new to MS SQL Server 2000 and would like to clarify what I was
confused:
What should I do if I want to do a full backup at Sunday 5 pm, differential
backup Monday to Friday and transaction log every 4 hours Monday to Friday.
Should I do that by setting up in Database Maintenance Plans
OR
Backup
under the Management folder in Enterprise Manager ?
Does anyone has a pointer to this typical backup steps please ?
Alan
Visit at
<http://vyaskn.tripod.com/sql_server_...ices.htm#Step1
> --administaiting best practices
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eYbhNktyEHA.2752@.TK2MSFTNGP11.phx.gbl...
> I just new to MS SQL Server 2000 and would like to clarify what I was
> confused:
> What should I do if I want to do a full backup at Sunday 5 pm,
differential
> backup Monday to Friday and transaction log every 4 hours Monday to
Friday.
> Should I do that by setting up in Database Maintenance Plans
> OR
> Backup
> under the Management folder in Enterprise Manager ?
> Does anyone has a pointer to this typical backup steps please ?
>
sql
confused:
What should I do if I want to do a full backup at Sunday 5 pm, differential
backup Monday to Friday and transaction log every 4 hours Monday to Friday.
Should I do that by setting up in Database Maintenance Plans
OR
Backup
under the Management folder in Enterprise Manager ?
Does anyone has a pointer to this typical backup steps please ?
Alan
Visit at
<http://vyaskn.tripod.com/sql_server_...ices.htm#Step1
> --administaiting best practices
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eYbhNktyEHA.2752@.TK2MSFTNGP11.phx.gbl...
> I just new to MS SQL Server 2000 and would like to clarify what I was
> confused:
> What should I do if I want to do a full backup at Sunday 5 pm,
differential
> backup Monday to Friday and transaction log every 4 hours Monday to
Friday.
> Should I do that by setting up in Database Maintenance Plans
> OR
> Backup
> under the Management folder in Enterprise Manager ?
> Does anyone has a pointer to this typical backup steps please ?
>
sql
Backup questions
I just new to MS SQL Server 2000 and would like to clarify what I was
confused:
What should I do if I want to do a full backup at Sunday 5 pm, differential
backup Monday to Friday and transaction log every 4 hours Monday to Friday.
Should I do that by setting up in Database Maintenance Plans
OR
Backup
under the Management folder in Enterprise Manager ?
Does anyone has a pointer to this typical backup steps please ?Alan
Visit at
<http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1
> --administaiting best practices
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eYbhNktyEHA.2752@.TK2MSFTNGP11.phx.gbl...
> I just new to MS SQL Server 2000 and would like to clarify what I was
> confused:
> What should I do if I want to do a full backup at Sunday 5 pm,
differential
> backup Monday to Friday and transaction log every 4 hours Monday to
Friday.
> Should I do that by setting up in Database Maintenance Plans
> OR
> Backup
> under the Management folder in Enterprise Manager ?
> Does anyone has a pointer to this typical backup steps please ?
>
confused:
What should I do if I want to do a full backup at Sunday 5 pm, differential
backup Monday to Friday and transaction log every 4 hours Monday to Friday.
Should I do that by setting up in Database Maintenance Plans
OR
Backup
under the Management folder in Enterprise Manager ?
Does anyone has a pointer to this typical backup steps please ?Alan
Visit at
<http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1
> --administaiting best practices
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eYbhNktyEHA.2752@.TK2MSFTNGP11.phx.gbl...
> I just new to MS SQL Server 2000 and would like to clarify what I was
> confused:
> What should I do if I want to do a full backup at Sunday 5 pm,
differential
> backup Monday to Friday and transaction log every 4 hours Monday to
Friday.
> Should I do that by setting up in Database Maintenance Plans
> OR
> Backup
> under the Management folder in Enterprise Manager ?
> Does anyone has a pointer to this typical backup steps please ?
>
Backup questions
I just new to MS SQL Server 2000 and would like to clarify what I was
confused:
What should I do if I want to do a full backup at Sunday 5 pm, differential
backup Monday to Friday and transaction log every 4 hours Monday to Friday.
Should I do that by setting up in Database Maintenance Plans
OR
Backup
under the Management folder in Enterprise Manager ?
Does anyone has a pointer to this typical backup steps please ?Alan
Visit at
<http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
> --administaiting best practices
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eYbhNktyEHA.2752@.TK2MSFTNGP11.phx.gbl...
> I just new to MS SQL Server 2000 and would like to clarify what I was
> confused:
> What should I do if I want to do a full backup at Sunday 5 pm,
differential
> backup Monday to Friday and transaction log every 4 hours Monday to
Friday.
> Should I do that by setting up in Database Maintenance Plans
> OR
> Backup
> under the Management folder in Enterprise Manager ?
> Does anyone has a pointer to this typical backup steps please ?
>
confused:
What should I do if I want to do a full backup at Sunday 5 pm, differential
backup Monday to Friday and transaction log every 4 hours Monday to Friday.
Should I do that by setting up in Database Maintenance Plans
OR
Backup
under the Management folder in Enterprise Manager ?
Does anyone has a pointer to this typical backup steps please ?Alan
Visit at
<http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
> --administaiting best practices
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eYbhNktyEHA.2752@.TK2MSFTNGP11.phx.gbl...
> I just new to MS SQL Server 2000 and would like to clarify what I was
> confused:
> What should I do if I want to do a full backup at Sunday 5 pm,
differential
> backup Monday to Friday and transaction log every 4 hours Monday to
Friday.
> Should I do that by setting up in Database Maintenance Plans
> OR
> Backup
> under the Management folder in Enterprise Manager ?
> Does anyone has a pointer to this typical backup steps please ?
>
Saturday, February 25, 2012
Backup of Read Only Database.
Hi,
Is it possible to take backup of read only database?
If yes then
How? and
If No? then
There is any Microsoft official link which can clarify the answer.
please give reply as soon as possible.
Kind Regards,
Sajid.Hi,
Yes you can backup a read only database (confirmed it for myself on SQL
Server 2000 and 2005).
You can do it using Enterprise Manager (SQL Server 2000) or Management
Studio (SQL Server 2005). Alternatively, you can use T-SQL to do it
through the use of the BACKUP DATABASE statement.
SQL Server Books Online is a good resource to look up how to do it if
you need a refresher.
Hope that helps a bit|||Hi,
Thanks for this reply.
Can you pls. giveme the exact BACKUP DATABASE Statement.
Thanks and Regards,
Sajid.|||Hi,
Thanks for this reply.
Can you pls. giveme the exact BACKUP DATABASE Statement.
Thanks and Regards,
Sajid.|||Hi,
If you want to back up your database to a file, then your statement
should look like:
BACKUP DATABASE <Insert Database Name>
TO DISK = 'C:\Example_Backup.bak'
Hope that helps a bit|||Hi,
Thanks for your quick reply.
Again i want to know that can i take a backup of database which is in
standby mode.
if the ans. is yes then pls. tell me how can i do it?
Thanks and Regards,
Sajid.
nate.vu@.gmail.com wrote:
> Hi,
> If you want to back up your database to a file, then your statement
> should look like:
> BACKUP DATABASE <Insert Database Name>
> TO DISK = 'C:\Example_Backup.bak'
> Hope that helps a bit|||Read only is not the same as standby mode. Unfortunately, I believe that the tools that comes with
SQL Server blurs this. No, you cannot take a backup of a database in standby mode (restored using
the STANDBY option).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<csajid@.gmail.com> wrote in message news:1147689430.310228.284590@.v46g2000cwv.googlegroups.com...
> Hi,
> Thanks for your quick reply.
> Again i want to know that can i take a backup of database which is in
> standby mode.
> if the ans. is yes then pls. tell me how can i do it?
> Thanks and Regards,
> Sajid.
>
> nate.vu@.gmail.com wrote:
>> Hi,
>> If you want to back up your database to a file, then your statement
>> should look like:
>> BACKUP DATABASE <Insert Database Name>
>> TO DISK = 'C:\Example_Backup.bak'
>> Hope that helps a bit
>
Is it possible to take backup of read only database?
If yes then
How? and
If No? then
There is any Microsoft official link which can clarify the answer.
please give reply as soon as possible.
Kind Regards,
Sajid.Hi,
Yes you can backup a read only database (confirmed it for myself on SQL
Server 2000 and 2005).
You can do it using Enterprise Manager (SQL Server 2000) or Management
Studio (SQL Server 2005). Alternatively, you can use T-SQL to do it
through the use of the BACKUP DATABASE statement.
SQL Server Books Online is a good resource to look up how to do it if
you need a refresher.
Hope that helps a bit|||Hi,
Thanks for this reply.
Can you pls. giveme the exact BACKUP DATABASE Statement.
Thanks and Regards,
Sajid.|||Hi,
Thanks for this reply.
Can you pls. giveme the exact BACKUP DATABASE Statement.
Thanks and Regards,
Sajid.|||Hi,
If you want to back up your database to a file, then your statement
should look like:
BACKUP DATABASE <Insert Database Name>
TO DISK = 'C:\Example_Backup.bak'
Hope that helps a bit|||Hi,
Thanks for your quick reply.
Again i want to know that can i take a backup of database which is in
standby mode.
if the ans. is yes then pls. tell me how can i do it?
Thanks and Regards,
Sajid.
nate.vu@.gmail.com wrote:
> Hi,
> If you want to back up your database to a file, then your statement
> should look like:
> BACKUP DATABASE <Insert Database Name>
> TO DISK = 'C:\Example_Backup.bak'
> Hope that helps a bit|||Read only is not the same as standby mode. Unfortunately, I believe that the tools that comes with
SQL Server blurs this. No, you cannot take a backup of a database in standby mode (restored using
the STANDBY option).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<csajid@.gmail.com> wrote in message news:1147689430.310228.284590@.v46g2000cwv.googlegroups.com...
> Hi,
> Thanks for your quick reply.
> Again i want to know that can i take a backup of database which is in
> standby mode.
> if the ans. is yes then pls. tell me how can i do it?
> Thanks and Regards,
> Sajid.
>
> nate.vu@.gmail.com wrote:
>> Hi,
>> If you want to back up your database to a file, then your statement
>> should look like:
>> BACKUP DATABASE <Insert Database Name>
>> TO DISK = 'C:\Example_Backup.bak'
>> Hope that helps a bit
>
Backup of Read Only Database.
Hi,
Is it possible to take backup of read only database?
If yes then
How? and
If No? then
There is any Microsoft official link which can clarify the answer.
please give reply as soon as possible.
Kind Regards,
Sajid.Hi,
Yes you can backup a read only database (confirmed it for myself on SQL
Server 2000 and 2005).
You can do it using Enterprise Manager (SQL Server 2000) or Management
Studio (SQL Server 2005). Alternatively, you can use T-SQL to do it
through the use of the BACKUP DATABASE statement.
SQL Server Books Online is a good resource to look up how to do it if
you need a refresher.
Hope that helps a bit|||Hi,
Thanks for this reply.
Can you pls. giveme the exact BACKUP DATABASE Statement.
Thanks and Regards,
Sajid.|||Hi,
Thanks for this reply.
Can you pls. giveme the exact BACKUP DATABASE Statement.
Thanks and Regards,
Sajid.|||Hi,
If you want to back up your database to a file, then your statement
should look like:
BACKUP DATABASE <Insert Database Name>
TO DISK = 'C:\Example_Backup.bak'
Hope that helps a bit|||Hi,
Thanks for your quick reply.
Again i want to know that can i take a backup of database which is in
standby mode.
if the ans. is yes then pls. tell me how can i do it?
Thanks and Regards,
Sajid.
nate.vu@.gmail.com wrote:
> Hi,
> If you want to back up your database to a file, then your statement
> should look like:
> BACKUP DATABASE <Insert Database Name>
> TO DISK = 'C:\Example_Backup.bak'
> Hope that helps a bit|||Read only is not the same as standby mode. Unfortunately, I believe that the
tools that comes with
SQL Server blurs this. No, you cannot take a backup of a database in standby
mode (restored using
the STANDBY option).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<csajid@.gmail.com> wrote in message news:1147689430.310228.284590@.v46g2000cwv.googlegroups.c
om...
> Hi,
> Thanks for your quick reply.
> Again i want to know that can i take a backup of database which is in
> standby mode.
> if the ans. is yes then pls. tell me how can i do it?
> Thanks and Regards,
> Sajid.
>
> nate.vu@.gmail.com wrote:
>
Is it possible to take backup of read only database?
If yes then
How? and
If No? then
There is any Microsoft official link which can clarify the answer.
please give reply as soon as possible.
Kind Regards,
Sajid.Hi,
Yes you can backup a read only database (confirmed it for myself on SQL
Server 2000 and 2005).
You can do it using Enterprise Manager (SQL Server 2000) or Management
Studio (SQL Server 2005). Alternatively, you can use T-SQL to do it
through the use of the BACKUP DATABASE statement.
SQL Server Books Online is a good resource to look up how to do it if
you need a refresher.
Hope that helps a bit|||Hi,
Thanks for this reply.
Can you pls. giveme the exact BACKUP DATABASE Statement.
Thanks and Regards,
Sajid.|||Hi,
Thanks for this reply.
Can you pls. giveme the exact BACKUP DATABASE Statement.
Thanks and Regards,
Sajid.|||Hi,
If you want to back up your database to a file, then your statement
should look like:
BACKUP DATABASE <Insert Database Name>
TO DISK = 'C:\Example_Backup.bak'
Hope that helps a bit|||Hi,
Thanks for your quick reply.
Again i want to know that can i take a backup of database which is in
standby mode.
if the ans. is yes then pls. tell me how can i do it?
Thanks and Regards,
Sajid.
nate.vu@.gmail.com wrote:
> Hi,
> If you want to back up your database to a file, then your statement
> should look like:
> BACKUP DATABASE <Insert Database Name>
> TO DISK = 'C:\Example_Backup.bak'
> Hope that helps a bit|||Read only is not the same as standby mode. Unfortunately, I believe that the
tools that comes with
SQL Server blurs this. No, you cannot take a backup of a database in standby
mode (restored using
the STANDBY option).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<csajid@.gmail.com> wrote in message news:1147689430.310228.284590@.v46g2000cwv.googlegroups.c
om...
> Hi,
> Thanks for your quick reply.
> Again i want to know that can i take a backup of database which is in
> standby mode.
> if the ans. is yes then pls. tell me how can i do it?
> Thanks and Regards,
> Sajid.
>
> nate.vu@.gmail.com wrote:
>
Subscribe to:
Posts (Atom)