Re: Transaction log
From: Bryan (Juniper2000_at_hotmail.com)
Date: 09/16/04
- Next message: Bryan: "Re: Assigning a default date as a Parameter"
- Previous message: Just D.: "Transaction log"
- In reply to: Just D.: "Transaction log"
- Next in thread: Just D.: "Re: Transaction log"
- Reply: Just D.: "Re: Transaction log"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Sep 2004 04:43:49 GMT
If you are asking if you can restore a database from using only transaction
logs, the answer is no. You need the last database backup and sequential
transactions to restore to a specific point in time. Transaction logs are
applied to a physical database schema. To restore fro logs only is like
saying "DELETE FROM Customers" (This being a transaction) when the Customers
table does not exist, or anything else (including the database object
itself) for that matter.
-- Bryan Bitzer MCP Senior Database Administrator Marshall & Swift / Boeckh www.msbinfo.com "Just D." <no@spam.please> wrote in message news:HI82d.40566$9Y5.22419@fed1read02... > Can we restore the MSSQL Server 2000 database from the transaction log? > > Just D. > >
- Next message: Bryan: "Re: Assigning a default date as a Parameter"
- Previous message: Just D.: "Transaction log"
- In reply to: Just D.: "Transaction log"
- Next in thread: Just D.: "Re: Transaction log"
- Reply: Just D.: "Re: Transaction log"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
