Restore Database problem

Hi Gurus,
I am doing Backup and Restore.
But while restore it restore from the previous backup.
What am I doing wrong.
BACKUP DATABASE TestDB TO DISK = 'c:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\TestDB.bak'
RESTORE DATABASE TestDb FROM disk='c:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\TestDB.bak'
Please reply. I am desperate.
RCDo you have more than one backup in that device? If so you must specify
which one.
Andrew J. Kelly SQL MVP
"Richard" <Richard@.nospam.com> wrote in message
news:e2az9GbHFHA.3352@.TK2MSFTNGP10.phx.gbl...
> Hi Gurus,
> I am doing Backup and Restore.
> But while restore it restore from the previous backup.
> What am I doing wrong.
> BACKUP DATABASE TestDB TO DISK = 'c:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\TestDB.bak'
> RESTORE DATABASE TestDb FROM disk='c:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\TestDB.bak'
> Please reply. I am desperate.
> RC
>|||Yes, there are few backups. But how do I specify which one.
Thanks, Kartic
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23LN5HNbHFHA.2852@.TK2MSFTNGP12.phx.gbl...
> Do you have more than one backup in that device? If so you must specify
> which one.
> --
> Andrew J. Kelly SQL MVP
>
> "Richard" <Richard@.nospam.com> wrote in message
> news:e2az9GbHFHA.3352@.TK2MSFTNGP10.phx.gbl...
>|||Use the FILE option for the backup command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Richard" <Richard@.nospam.com> wrote in message news:OHtzzVbHFHA.3572@.TK2MSFTNGP14.phx.gbl.
.
> Yes, there are few backups. But how do I specify which one.
> Thanks, Kartic
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23LN5HNbHFHA.2852@.TK2MSFTNGP12.phx.gbl...
>