select *
into table b
from table a
-----Original Message-----
From: Bartholomew Okonkwo [mailto:[Email Address Removed]
Sent: Thursday, January 15, 2004 7:59 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
please can anyone remind me of the command to backup a table in the SQL
database
as in
create table b as select * from table a
i confuse this with oracle command, please reply asap. my txnlog is full and
i need to purge the table. my production is down right now
thanks
-----Original Message-----
From: anthony.[Email Address Removed] [mailto:anthony.[Email Address Removed] Thursday, January 15, 2004 5:24 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
trying using TSQL, it's actually quite painless......
/* restore the full backup this way*/
USE master
RESTORE DATABASE HOWCertificates
FROM DISK = 'Q:\database_backup_file_name.bak'
WITH STANDBY = 'E:\MSSQL7\log_file_name.log', REPLACE
/*now use the below script to restore the logs, one by one*/
USE master
RESTORE LOG [database_name]
FROM DISK = 'E:\MSSQL7\backup\database_name.Bak'
WITH NORECOVERY, FILE = [number of the backup, if first log backup put
1]
remember you have to restore the logs in sequence, and on the last one, take
the db out of recovery mode.
hope it helps.
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
"BLACK Greg"
<Greg.[Email Address Removed] To: "LazyDBA.com
Discussion" <[Email Address Removed]
ell.com> cc:
bcc:
15/01/2004 03:05 Subject: RE: Problem with
recovery of transaction logs
PM
Doing the restore through EM. I've never done one using TSQL. I'm more
familiar with Oracle than SQLServer, so EM has been easier for me so far. Is
there something in the restore in TSQL that I cant do using the GUI ??
-----Original Message-----
From: Richard Ridge [mailto:[Email Address Removed] Thursday, 15 January 2004 11:57 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
how are you doing the restore? through EM or TSQL
-----Original Message-----
From: BLACK Greg [mailto:Greg.[Email Address Removed] Thursday, 15 January 2004 10:17 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
Recovery mode is Full.
-----Original Message-----
From: Richard Ridge [mailto:[Email Address Removed] Thursday, 15 January 2004 8:58 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
check what recovery mode your database is in
-----Original Message-----
From: BLACK Greg [mailto:Greg.[Email Address Removed] Thursday, 15 January 2004 9:34 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
Hi Anthony,
Thanks for the reply. The transaction log I'm trying to restore from is the
one that was backed up after the full backup that I recovered from, so I
doubt it would be from an older backup set. Fortunately we are only testing
our DR procedures and this is not a real recovery. But if we ever have to
use it, I'm stuffed with this DB, unless I sort this out. I have tried a
different backup from a different day, and tried to recover the trans log
that was backed up immediately after the full backup, and this also fails.
Blackie
-----Original Message-----
From: anthony.[Email Address Removed] [mailto:anthony.[Email Address Removed] Thursday, 15 January 2004 7:51 AM
To: BLACK Greg
Cc: LazyDBA.com Discussion
Subject: Re: Problem with recovery of transaction logs
Sorry, what am i saying.
The Transaction log.... could it be that this is from an older backup set,
could it have been made after the full backup was executed?
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
"BLACK Greg"
<Greg.[Email Address Removed] To: "LazyDBA.com
Discussion" <[Email Address Removed] ell.com> cc:
bcc:
14/01/2004 05:38 Subject: Problem with
recovery of transaction logs
PM
Hi all,
I'm having a problem trying to restore a database using a full backup and
then applying transaction logs to roll forward. We are using SQL 2000 on
Win2000 server. The steps I'm doing are 1. Recover database from full backup
( time of backup 22:30), leave DB in R/O state able to restore additional
trans logs - This works OK. 2. Attempt to roll forward by applying the 1st
transaction log after the backup - This fails with the following error ( The
log in this backup set cannot be applied because it is not on a recovery
path consistent with the database )
How can this be ?? I have done this on other DB's successfully, but it will
not work for this one. Are there any options etc that can be set to stop me
applying the trans log to the DB ??
Any help would be greatly appreciated.
Blackie
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] "The information contained in this email and any attached files
is strictly private and confidential. This email should be
read by the intended addressee only. If the recipient of this
message is not the intended addressee, please call Aon Risk
Services Australia, Aon Consulting, Aon Re Australia Ltd and
other associated Aon Companies on +61 2 92537000 and promptly
delete this email and any attachments.
The intended recipient of this email may only use, reproduce,
disclose or distribute the information contained in this email
and any attached files with Aon's permission. If you are not
the intended addressee, you are strictly prohibited from using,
reproducing, disclosing or distributing the information
contained in this email and any attached files.
Aon advises that this email and any attached files should be
scanned to detect viruses. Aon accepts no liability for loss
or damage (whether caused by negligence or not) resulting from
the use of any attached files."
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] information contained in this email and any attached files is strictly
private and confidential. This email should be read by the intended
addressee only. If the recipient of this message is not the intended
addressee, please call Aon Risk Services Australia, Aon Consulting, Aon Re
Australia Ltd and other associated Aon Companies on +61 2 92537000 and
promptly delete this email and any attachments.
The intended recipient of this email may only use, reproduce, disclose or
distribute the information contained in this email and any attached files
with Aon's permission. If you are not the intended addressee, you are
strictly prohibited from using, reproducing, disclosing or distributing the
information contained in this email and any attached files.
Aon advises that this email and any attached files should be scanned to
detect viruses. Aon accepts no liability for loss or damage (whether caused
by negligence or not) resulting from the use of any attached files."
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] The Information contained and transmitted by this
E-MAIL is proprietary to Diamond Bank and/or its Customer and is intended
for use only by the individual or entity to which it is addressed, and may
contain information that is privileged, confidential or exempt from a
disclosure under applicable law. If this is a forwarded message, the content
of this E-MAIL may not have been sent with the authority of the Bank.
Diamond Bank shall not be liable for any mails sent without due
authorisation or through unauthorised access. If you are not the intended
recipient, an agent of the intended recipient or a person responsible for
delivering the information to the named recipient, you are notified that any
use, distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail and notify us
immediately at [Email Address Removed]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed]
This is a commercial communication from Commerzbank AG.
This communication is confidential and is intended only for the person to
whom it is addressed. If you are not that person you are not permitted to
make use of the information and you are requested to notify
<mailto:LONIB.[Email Address Removed] immediately that you have
received it and then destroy the copy in your possession.
Commerzbank AG may monitor outgoing and incoming e-mails. By replying to
this e-mail you consent to such monitoring. This e-mail message and any
attached files have been scanned for the presence of computer viruses.
However, you are advised that you open attachments at your own risk.
This email was sent either by Commerzbank AG, London Branch, or by
Commerzbank Securities, a division of Commerzbank. Commerzbank AG is a
limited liability company incorporated in the Federal Republic of Germany.
Registered Company Number in England BR001025. Our registered address in
the UK is 23 Austin Friars, London, EC2P 2JD. We are regulated by the
Financial Services Authority for the conduct of investment business in the
UK and we appear on the FSA register under number 124920.
**********************************************************************
MS Sql Server LazyDBA home page