Bartholomew ,
Use the following :-
Select * into table b from table a
Stuart
-----Original Message-----
From: Bartholomew Okonkwo [mailto:[Email Address Removed] 15 January 2004 07:59
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] 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] 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] 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] 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] 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] 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] additional commands, e-mail: mssqldba-[Email Address Removed] 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] additional commands, e-mail: mssqldba-[Email Address Removed] message (including any attachments) is confidential and may be
legally privileged. If you are not the intended recipient, you should
not disclose, copy or use any part of it - please delete all copies
immediately and notify the Endeva IT Department on +44 (0)1793 889855
Any information, statements or opinions contained in this message
(including any attachments) are given solely by the author. They are not
given on behalf of Endeva unless specifically stated herein.
This footnote confirms that this e-mail message and any files transmitted
with it have been swept for the presence of computer viruses. You are
nevertheless advised to perform virus checking on receipt to avoid any
possible infection.
AV Lomas, JG Parr and D Howell have been appointed as joint administrative
receivers of Endeva Service Limited, Endeva Fulfilment Limited
and Endeva Materials Supply Limited. AV Lomas, JG Parr and D Howell
act as agent of Endeva Service Limitied, Endeva Fulfilment Limited
and Endeva Materials Supply Limited and contract without personal liability.
AV Lomas, JG Parr and D Howell are licensed to act as insolvency practitioners
by the Institute of Chartered Accountants in England and Wales.
Santana Building,
Westlea Campus,
Chelmsford Road,
SWINDON
SN5 7EY
www.endeva.co.uk
***************************************************************************
MS Sql Server LazyDBA home page