|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Roll back databaseI have a database running with Full Logging. Now I would like to have
that database copied to another one, together with the full log. Roll back the log (in the copied database) for 6 days and then copy a table to the original database. How do I best do this? In steps? -- Thanks in advance, Stijn Verrept. "Stijn Verrept" <st***@entrysoft.com> wrote in message
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpc_6pv6.asp
news:XrydnQhF5sqOrhveRVnyiQ@scarlet.biz... >I have a database running with Full Logging. Now I would like to have > that database copied to another one, together with the full log. Roll > back the log (in the copied database) for 6 days and then copy a table > to the original database. How do I best do this? In steps? > > -- > > Thanks in advance, > > Stijn Verrept. --
David Portas SQL Server MVP -- David Portas wrote:
Thanks for the answer David, however, I know how to restore from a backup to a certain point in time but I only have the database running now, without any backup files (but with a big log). How do I do it like that? -- Thanks, Stijn Verrept.
Show quote
"Stijn Verrept" <st***@entrysoft.com> wrote in message You'll have to back it up first. Take a database backup, then a log backup. news:fpWdnTeQDej7qBveRVnyiw@scarlet.biz... > David Portas wrote: > >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howto >> sql/ht_7_backpc_6pv6.asp > > Thanks for the answer David, however, I know how to restore from a > backup to a certain point in time but I only have the database running > now, without any backup files (but with a big log). How do I do it > like that? > > -- > > Thanks, > > Stijn Verrept. You can't recover from a log file itself. -- David Portas SQL Server MVP -- David Portas wrote:
> You'll have to back it up first. Take a database backup, then a log True but then the database is restored to the state of the backup,> backup. You can't recover from a log file itself. applying the log doesn't do anything then. I mean I can't go back earlier then the moment when I take the backup or am I missing something? -- Kind regards, Stijn Verrept.
Show quote
"Stijn Verrept" <st***@entrysoft.com> wrote in message I see. You are correct there. Restore to a point in time before the first news:Sr6dnYrhE7H03BveRVnygQ@scarlet.biz... > David Portas wrote: > >> You'll have to back it up first. Take a database backup, then a log >> backup. You can't recover from a log file itself. > > True but then the database is restored to the state of the backup, > applying the log doesn't do anything then. I mean I can't go back > earlier then the moment when I take the backup or am I missing > something? > > -- > > Kind regards, > > Stijn Verrept. database backup isn't possible. If this is critical for you then you could take a look at third-party products like Lumigent Log Explorer. You may be able to salvage something from the log. http://www.lumigent.com/products/le_sql.html -- David Portas SQL Server MVP -- You need to have a backup strategy that performs FULL BACKUP in combination
with Transaction Log. You would be able to restore the full backup and all the transaction log backups without initiating recovery and perform a POINT IN TIME RECOVERY (Use Lumigent Log Explorer to look upto what moment you wish to revert..) If you don't have a FULL BACKUP initially and no transaction log backups you won't be able to initiate point in time recovery. Groeten uit Sint-Niklaas! -- Show quoteDandy Weyn [MCSE-MCSA-MCDBA-MCDST-MCT Community Leader] SQL Server Technologist http://www.dandyman.net Check my SQL Server Resource Pages at http://www.dandyman.net/sql "Stijn Verrept" <st***@entrysoft.com> wrote in message news:XrydnQhF5sqOrhveRVnyiQ@scarlet.biz... >I have a database running with Full Logging. Now I would like to have > that database copied to another one, together with the full log. Roll > back the log (in the copied database) for 6 days and then copy a table > to the original database. How do I best do this? In steps? > > -- > > Thanks in advance, > > Stijn Verrept. Dandy Weyn [Dandyman] wrote:
> If you don't have a FULL BACKUP initially and no transaction log Thanks a lot, that's what I needed to know. We have the backups on> backups you won't be able to initiate point in time recovery. > > Groeten uit Sint-Niklaas! tape so I'll be able to restore but I wanted to know if there was a way of doing it without the backups (so I could do it right now remotely). -- Thanks, Stijn Verrept. BTW Groeten vanuit Bornem ;)  
Other interesting topics
|
|||||||||||||||||||||||
