Restore question

While doing a reorganize on Friday, the drive filled up, and the operation
failed with an error. The database on the next full backup went from 1.5 gig
to 3 gig in size. (full backup occurs every 24 hours).
I have tran-logs created every hour and a full backup from the day before
(Thursday). Can I restore the Thursday backup and then restore all tran-logs
(Thursday, Friday, Saturday, Sunday, Monday, and Tuesday) and expect to have
all my data or can I only restore up to the point of my next full backup
(Saturday)?
Thank you
G.Hi,
Why do you need to restore the database? Because your current database is
still available. Based on your mail I feel that your
Backup file size has grown from 1.5 GB to 3 GB.
I feel that this growth is because of the Reorginization activity. I think
the backup file size can be solved by just shrinking the Log file.
How to shrink the log file:
1. Backup the Transaction log (Use Backup Log command)
2. Use dbcc shrink file to shrink the file
See the below link for shrinking the transaction log file.
http://support.microsoft.com/defaul...b;EN-US;q272318
Thanks
Hari
MCDBA
"Ric Griffy" <alakevue.at@.tampabay.rr.com> wrote in message
news:QA78c.333946$Po1.285683@.twister.tampabay.rr.com...
> While doing a reorganize on Friday, the drive filled up, and the operation
> failed with an error. The database on the next full backup went from 1.5
gig
> to 3 gig in size. (full backup occurs every 24 hours).
> I have tran-logs created every hour and a full backup from the day before
> (Thursday). Can I restore the Thursday backup and then restore all
tran-logs
> (Thursday, Friday, Saturday, Sunday, Monday, and Tuesday) and expect to
have
> all my data or can I only restore up to the point of my next full backup
> (Saturday)?
> Thank you
> G.
>
>|||I agree with Hari that nothing from your description indicates that you need
to do a restore.
To answer the direct question: Yes, you can skip restoring a database
backup. Performing a database backup does not break the chain of log
backups. This is one of the reasons why the log *is not* truncated when you
perform a database backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Ric Griffy" <alakevue.at@.tampabay.rr.com> wrote in message
news:QA78c.333946$Po1.285683@.twister.tampabay.rr.com...
> While doing a reorganize on Friday, the drive filled up, and the operation
> failed with an error. The database on the next full backup went from 1.5
gig
> to 3 gig in size. (full backup occurs every 24 hours).
> I have tran-logs created every hour and a full backup from the day before
> (Thursday). Can I restore the Thursday backup and then restore all
tran-logs
> (Thursday, Friday, Saturday, Sunday, Monday, and Tuesday) and expect to
have
> all my data or can I only restore up to the point of my next full backup
> (Saturday)?
> Thank you
> G.
>
>