|
Home > Archive > MS SQL Server > July 2005 > restore db without the log?
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 db without the log?
|
|
| ChrisR 2005-07-14, 8:23 pm |
| Is it possible in sql2k to restore a db without restoring the transaction
log? If so, how?
TIA, ChrisR
| |
| Hari Prasad 2005-07-14, 8:23 pm |
| Hi,
If you have the FULL Database backup you could restore the full database.
See RESTORE DATABASE command in books online.
Log restore will help you to recover the database till POINT IN TIME.
Thanks
Hari
SQL Server MVP
"ChrisR" <noemail@bla.com> wrote in message
news:OMubP%23LiFHA.3476@TK2MSFTNGP10.phx.gbl...
> Is it possible in sql2k to restore a db without restoring the transaction
> log? If so, how?
>
> TIA, ChrisR
>
| |
| ChrisR 2005-07-14, 8:23 pm |
| Hari, I have a FULL backup and want to restore the full db, minus the 20 gig
transaction log.
"Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
news:ezKnNAMiFHA.392@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> If you have the FULL Database backup you could restore the full database.
> See RESTORE DATABASE command in books online.
> Log restore will help you to recover the database till POINT IN TIME.
>
> Thanks
> Hari
> SQL Server MVP
>
> "ChrisR" <noemail@bla.com> wrote in message
> news:OMubP%23LiFHA.3476@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Andrew J. Kelly 2005-07-15, 3:23 am |
| If you mean without creating the transaction log file then no. The restore
process from a FULL backup will always rebuild the db and log files exactly
as they were when you made the backup. You can detach the db and attach it
with sing_file_db and it will create a new log file. I am not sure how
large it makes the new file though. It's probably the size you originally
created it at or explicitly did an alter file on it.
--
Andrew J. Kelly SQL MVP
"ChrisR" <noemail@bla.com> wrote in message
news:%23dKNBNMiFHA.3716@TK2MSFTNGP14.phx.gbl...
> Hari, I have a FULL backup and want to restore the full db, minus the 20
> gig transaction log.
>
>
> "Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
> news:ezKnNAMiFHA.392@TK2MSFTNGP10.phx.gbl...
>
>
|
|
|
|
|