Restore a single table

I wanna restore a single table (example material) that I created on a
filegroup (example, sales). I have four filegroups.
I did a filegroup backup, but I don't want restore all filegroups, I want
restore only sales filegroup because it has my table.
I used :
CREATE TABLE material (id int) ON sales
BACKUP DATABASE Teste
FILE = 'TesteData1',
FILEGROUP = 'x',
FILE = 'TesteData2',
FILEGROUP = 'sales'
..
TO Teste1F
with init
GO
backup log Teste to Teste1L with noinit
GO
could I use this command :
restore DATABASE Teste
FILE = 'TesteData2',
FILEGROUP = 'Sales'
from Teste1F
with norecovery
GO
restore LOG teste from Teste1L
WITH recovery, file=1
But I used but this is not good for me.. the table disappear
thanks a lotPartial Database Restore Operations
http://msdn.microsoft.com/library/d... />
t_71f7.asp
AMB
"M?nica" wrote:

> I wanna restore a single table (example material) that I created on a
> filegroup (example, sales). I have four filegroups.
> I did a filegroup backup, but I don't want restore all filegroups, I want
> restore only sales filegroup because it has my table.
> I used :
> CREATE TABLE material (id int) ON sales
> BACKUP DATABASE Teste
> FILE = 'TesteData1',
> FILEGROUP = 'x',
> FILE = 'TesteData2',
> FILEGROUP = 'sales'
> ...
> TO Teste1F
> with init
> GO
> backup log Teste to Teste1L with noinit
> GO
> could I use this command :
> restore DATABASE Teste
> FILE = 'TesteData2',
> FILEGROUP = 'Sales'
> from Teste1F
> with norecovery
> GO
> restore LOG teste from Teste1L
> WITH recovery, file=1
> But I used but this is not good for me.. the table disappear
> thanks a lot

Restore a single table

Hi,

I have a problem. For some reason I needed to restore a single (large) table that shares a filegroup with other tables. I have a full backup of the database. How can I restore my particular table?

-- Srinivas

Unfortunately this is not possible with builtin functions. There are onyl a few options. Restore the whole database to a new destination and copy the table to the final destination where you want to restore it. Use a third party tool which is able to extract only a single table from a backup media.

HTH, Jens Suessmeyer.

|||Thank you, Jens Suessmeyer.

Restore a single table

I wanna restore a single table (example material) that I created on a
filegroup (example, sales). I have four filegroups.
I did a filegroup backup, but I don't want restore all filegroups, I want
restore only sales filegroup because it has my table.
I used :
CREATE TABLE material (id int) ON sales
BACKUP DATABASE Teste
FILE = 'TesteData1',
FILEGROUP = 'x',
FILE = 'TesteData2',
FILEGROUP = 'sales'
...
TO Teste1F
with init
GO
backup log Teste to Teste1L with noinit
GO
could I use this command :
restore DATABASE Teste
FILE = 'TesteData2',
FILEGROUP = 'Sales'
from Teste1F
with norecovery
GO
restore LOG teste from Teste1L
WITH recovery, file=1
But I used but this is not good for me.. the table disappear
thanks a lot
Partial Database Restore Operations
http://msdn.microsoft.com/library/de...kprst_71f7.asp
AMB
"M?nica" wrote:

> I wanna restore a single table (example material) that I created on a
> filegroup (example, sales). I have four filegroups.
> I did a filegroup backup, but I don't want restore all filegroups, I want
> restore only sales filegroup because it has my table.
> I used :
> CREATE TABLE material (id int) ON sales
> BACKUP DATABASE Teste
> FILE = 'TesteData1',
> FILEGROUP = 'x',
> FILE = 'TesteData2',
> FILEGROUP = 'sales'
> ...
> TO Teste1F
> with init
> GO
> backup log Teste to Teste1L with noinit
> GO
> could I use this command :
> restore DATABASE Teste
> FILE = 'TesteData2',
> FILEGROUP = 'Sales'
> from Teste1F
> with norecovery
> GO
> restore LOG teste from Teste1L
> WITH recovery, file=1
> But I used but this is not good for me.. the table disappear
> thanks a lot

Restore a single table

I wanna restore a single table (example material) that I created on a
filegroup (example, sales). I have four filegroups.
I did a filegroup backup, but I don't want restore all filegroups, I want
restore only sales filegroup because it has my table.
I used :
CREATE TABLE material (id int) ON sales
BACKUP DATABASE Teste
FILE = 'TesteData1',
FILEGROUP = 'x',
FILE = 'TesteData2',
FILEGROUP = 'sales'
...
TO Teste1F
with init
GO
backup log Teste to Teste1L with noinit
GO
could I use this command :
restore DATABASE Teste
FILE = 'TesteData2',
FILEGROUP = 'Sales'
from Teste1F
with norecovery
GO
restore LOG teste from Teste1L
WITH recovery, file=1
But I used but this is not good for me.. the table disappear
thanks a lotPartial Database Restore Operation
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_71f7.asp
AMB
"Mônica" wrote:
> I wanna restore a single table (example material) that I created on a
> filegroup (example, sales). I have four filegroups.
> I did a filegroup backup, but I don't want restore all filegroups, I want
> restore only sales filegroup because it has my table.
> I used :
> CREATE TABLE material (id int) ON sales
> BACKUP DATABASE Teste
> FILE = 'TesteData1',
> FILEGROUP = 'x',
> FILE = 'TesteData2',
> FILEGROUP = 'sales'
> ...
> TO Teste1F
> with init
> GO
> backup log Teste to Teste1L with noinit
> GO
> could I use this command :
> restore DATABASE Teste
> FILE = 'TesteData2',
> FILEGROUP = 'Sales'
> from Teste1F
> with norecovery
> GO
> restore LOG teste from Teste1L
> WITH recovery, file=1
> But I used but this is not good for me.. the table disappear
> thanks a lot

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.