Restoring File Backups II

Sorry, I want restore only two files ( one filegroup) of
database ( not full backup). I don't have the transaction
log backups created since the file backups. I don't care
about changes. I want restore only files and (optional)
last log backup.Typically file backups can only be restored on the same database where they
were performed. If you want to restore them to a different database, then
starting point for such a restore has to be a complete backup. If you want
to restore these file/filegroup backups to a different database then follow
the steps below :
- Restore complete backup with standby
- Restore all file/filegroup backups with standby
- Use DTS or BCP to get the data out of the filegroups (since you cannot
bring the restore database online unless you apply all transaction log
backups)
Also, you cannot restore only the last log backup. If you need changes from
the last log, you WILL need all log backups from the latest filegroup
backup that you applied.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Restoring File Backups II

Sorry, I want restore only two files ( one filegroup) of
database ( not full backup). I don't have the transaction
log backups created since the file backups. I don't care
about changes. I want restore only files and (optional)
last log backup.
Typically file backups can only be restored on the same database where they
were performed. If you want to restore them to a different database, then
starting point for such a restore has to be a complete backup. If you want
to restore these file/filegroup backups to a different database then follow
the steps below :
- Restore complete backup with standby
- Restore all file/filegroup backups with standby
- Use DTS or BCP to get the data out of the filegroups (since you cannot
bring the restore database online unless you apply all transaction log
backups)
Also, you cannot restore only the last log backup. If you need changes from
the last log, you WILL need all log backups from the latest filegroup
backup that you applied.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Restoring File Backups

"After restoring files, you must restore the transaction
log backups created since the file backups were created to
bring the database to a consistent state. The transaction
log backup can be rolled forward quickly, because only the
changes that apply to the restored files are applied."
I don't have the transaction log backups created since the
file backups. I don't care about changes. I want restore
only files and (optional) last log backup.
Can I do this ?
Hi,
You can do this. All you have to do is :-
1. Do a transaction log backup in your current database, provided your
recovery model is FULL or BULK_LOGGED
2. Now you can restore the full backup to a new database with NORECOVERY
option
See - RESTORE DATABASE command in books online
3. AFter the restore of FULL backup rectore the transaction log backup took
in step -1 with RECOVERY option
See - RESTORE LOG command in books online
Thanks
Hari
MCDBA
"MK" <anonymous@.discussions.microsoft.com> wrote in message
news:2e9ac01c46d6c$86a9d870$a601280a@.phx.gbl...
> "After restoring files, you must restore the transaction
> log backups created since the file backups were created to
> bring the database to a consistent state. The transaction
> log backup can be rolled forward quickly, because only the
> changes that apply to the restored files are applied."
> I don't have the transaction log backups created since the
> file backups. I don't care about changes. I want restore
> only files and (optional) last log backup.
> Can I do this ?

Restoring File Backups

"After restoring files, you must restore the transaction
log backups created since the file backups were created to
bring the database to a consistent state. The transaction
log backup can be rolled forward quickly, because only the
changes that apply to the restored files are applied."
I don't have the transaction log backups created since the
file backups. I don't care about changes. I want restore
only files and (optional) last log backup.
Can I do this ?Hi,
You can do this. All you have to do is :-
1. Do a transaction log backup in your current database, provided your
recovery model is FULL or BULK_LOGGED
2. Now you can restore the full backup to a new database with NORECOVERY
option
See - RESTORE DATABASE command in books online
3. AFter the restore of FULL backup rectore the transaction log backup took
in step -1 with RECOVERY option
See - RESTORE LOG command in books online
Thanks
Hari
MCDBA
"MK" <anonymous@.discussions.microsoft.com> wrote in message
news:2e9ac01c46d6c$86a9d870$a601280a@.phx
.gbl...
> "After restoring files, you must restore the transaction
> log backups created since the file backups were created to
> bring the database to a consistent state. The transaction
> log backup can be rolled forward quickly, because only the
> changes that apply to the restored files are applied."
> I don't have the transaction log backups created since the
> file backups. I don't care about changes. I want restore
> only files and (optional) last log backup.
> Can I do this ?