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...
>

Restore a filegroup/file to a Point In Time (PIT)

Can i restore a single filegroup (or file) to a previous point in time (say 8am), but keep the rest of the database unchanged (say 10am).

Or, does the whole database have to be at the same point in time after a restore of a specific filegroup. Or is it that everything has to be the same PIT as the PRIMARY.

tia

I'm not positive if you can restore a file to a specific point in time, but the database can do it, look: http://msdn2.microsoft.com/en-us/library/ms186858.aspx

|||Have a look at PIECEMEAL restore in BOoks online 2005 and also KBA http://support.microsoft.com/kb/281122 fyi.

Restore a filegroup/file to a Point In Time (PIT)

Can i restore a single filegroup (or file) to a previous point in time (say 8am), but keep the rest of the database unchanged (say 10am).

Or, does the whole database have to be at the same point in time after a restore of a specific filegroup. Or is it that everything has to be the same PIT as the PRIMARY.

tia

I'm not positive if you can restore a file to a specific point in time, but the database can do it, look: http://msdn2.microsoft.com/en-us/library/ms186858.aspx

|||Have a look at PIECEMEAL restore in BOoks online 2005 and also KBA http://support.microsoft.com/kb/281122 fyi.

Restore a filegroup

Can i restore a single filegroup (or file) to a previous point in time (say 8am), but keep the rest of the database unchanged (say 10am).

Or, does the whole database have to be at the same point in time after a restore of a specific filegroup.

The entire database has to be at the same point in time after a restore (of a specific filegroup).

Thanks

Sherry

|||Thank you. From what i have found out, that is correct. Too bad about that though. I'm sure the product will improve in that area one day.

Restore a filegroup

Can i restore a single filegroup (or file) to a previous point in time (say 8am), but keep the rest of the database unchanged (say 10am).

Or, does the whole database have to be at the same point in time after a restore of a specific filegroup.

The entire database has to be at the same point in time after a restore (of a specific filegroup).

Thanks

Sherry

|||Thank you. From what i have found out, that is correct. Too bad about that though. I'm sure the product will improve in that area one day.