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 advance
Perhaps 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