Wednesday, March 7, 2012

restore a differential backup into a database with a different name

I have a full back-up + differential backup of a database that I need to
restore onto another server. After I copied the backup onto the other
server, I selected restore from device and from its contents, I can see both
the full backup + differential backup. However, I am not able to restore
differential backup by checking the checkbox next to it. Any idea what I am
doing wrong? I am able to restore the full + differential backup into the
original db where the backups are made from.
Thanks in advancePerhaps some problem in the GUI (hard to tell without any error messages)?
I suggest you use Query Analyzer and the RESTORE command. You might want to investigate the backup
file(s) first using RESTORE and the HEADERONLY and FILELISTONLY options.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"CW" <CW@.nospam.com> wrote in message news:O2AeipQNFHA.3076@.TK2MSFTNGP14.phx.gbl...
>I have a full back-up + differential backup of a database that I need to restore onto another
>server. After I copied the backup onto the other server, I selected restore from device and from
>its contents, I can see both the full backup + differential backup. However, I am not able to
>restore differential backup by checking the checkbox next to it. Any idea what I am doing wrong? I
>am able to restore the full + differential backup into the original db where the backups are made
>from.
> Thanks in advance
>

No comments:

Post a Comment