|
Home > Archive > MS SQL Server > August 2005 > restore from full backup and transaction files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
restore from full backup and transaction files
|
|
| Simo Sentissi 2005-08-11, 1:24 pm |
| Hello there
I was wondering if there is a script outhere already written, that will take
the name of a full backup and a list of transaction files to build up a
database to the last transaction file ?
| |
|
|
| Hari Prasad 2005-08-11, 8:23 pm |
| Hi,
I recommend you to do this task manually. If you need to automate then see
the MSDB..BACKUPSET table.
This table contains all the backup informations.
Thanks
Hari
SQL Server MVP
"Simo Sentissi" <msentissi@rightnow.com> wrote in message
news:eUrBg3pnFHA.2904@TK2MSFTNGP14.phx.gbl...
> Hello there
>
> I was wondering if there is a script outhere already written, that will
> take the name of a full backup and a list of transaction files to build up
> a database to the last transaction file ?
>
>
>
| |
| Wayne Snyder 2005-08-11, 8:23 pm |
| Additionally if you select Restore from SQL Enterprise Manager, and select
the database torestore, it will automatically do everything including all
tran files to get you back...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Simo Sentissi" <msentissi@rightnow.com> wrote in message
news:eUrBg3pnFHA.2904@TK2MSFTNGP14.phx.gbl...
> Hello there
>
> I was wondering if there is a script outhere already written, that will
> take the name of a full backup and a list of transaction files to build up
> a database to the last transaction file ?
>
>
>
|
|
|
|
|