Hello All

I am currently doing a project on MS SQL Server 2005 where I am in
need of table level backup/restore. I know about FILEGROUP. But in
our project using FILEGROUP is not feasible. As far as I know MS SQL
Server 2005 does not support Table level restore directly. Moreover
relational integrity is also matter.

Is there any clever trick or 3rd party free software to do table level
restore/backup? Please Help.

Best regards
Nasif

Nasif
How about restoring the database with a different name and then transfer the
table's data. Think about , if the table has relationship with ohters
tables that get updated and you just bring the data from the past. Is it
possible that you get inconsistent data?



"Nasif" <nasif4003@gmail.com> wrote in message
news:f9aa03a1-26fa-4aed-8628-378a31355b72@m62g2000hsb.googlegroups.com...
> Hello All
>
> I am currently doing a project on MS SQL Server 2005 where I am in
> need of table level backup/restore. I know about FILEGROUP. But in
> our project using FILEGROUP is not feasible. As far as I know MS SQL
> Server 2005 does not support Table level restore directly. Moreover
> relational integrity is also matter.
>
> Is there any clever trick or 3rd party free software to do table level
> restore/backup? Please Help.
>
> Best regards
> Nasif

On Feb 6, 3:26 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
> Nasif
> How about restoring the database with a different name and then transfer the
> table's data. Think about , if the table has relationship with ohters
> tables that get updated and you just bring the data from the past. Is it
> possible that you get inconsistent data?
>
> "Nasif" <nasif4...@gmail.com> wrote in message
>
> news:f9aa03a1-26fa-4aed-8628-378a31355b72@m62g2000hsb.googlegroups.com...
>
> > Hello All
>
> > I am currently doing a project on MS SQL Server 2005 where I am in
> > need of table level backup/restore. I know about FILEGROUP. But in
> > our project using FILEGROUP is not feasible. As far as I know MS SQL
> > Server 2005 does not support Table level restore directly. Moreover
> > relational integrity is also matter.
>
> > Is there any clever trick or 3rd party free software to do table level
> > restore/backup? Please Help.
>
> > Best regards
> > Nasif

Dear Uri,

Thanks for ur answer. But still there is an overhead to restoring
whole database. Can u recommend another technique or any 3rd party
software?

Best Regards
Nasif

Nasif
How big is your db?

"Nasif" <nasif4003@gmail.com> wrote in message
news:3a707c47-85d0-40e1-abdc-4ed1df7998b8@i72g2000hsd.googlegroups.com...
> On Feb 6, 3:26 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>> Nasif
>> How about restoring the database with a different name and then transfer
>> the
>> table's data. Think about , if the table has relationship with ohters
>> tables that get updated and you just bring the data from the past. Is it
>> possible that you get inconsistent data?
>>
>> "Nasif" <nasif4...@gmail.com> wrote in message
>>
>> news:f9aa03a1-26fa-4aed-8628-378a31355b72@m62g2000hsb.googlegroups.com...
>>
>> > Hello All
>>
>> > I am currently doing a project on MS SQL Server 2005 where I am in
>> > need of table level backup/restore. I know about FILEGROUP. But in
>> > our project using FILEGROUP is not feasible. As far as I know MS SQL
>> > Server 2005 does not support Table level restore directly. Moreover
>> > relational integrity is also matter.
>>
>> > Is there any clever trick or 3rd party free software to do table level
>> > restore/backup? Please Help.
>>
>> > Best regards
>> > Nasif
>
> Dear Uri,
>
> Thanks for ur answer. But still there is an overhead to restoring
> whole database. Can u recommend another technique or any 3rd party
> software?
>
> Best Regards
> Nasif

Are you backing up your transaction logs? If so, you could use a log
explorer such as ApexSQL to recover rows modified (insert, deleted or
updated) for a specific table within a given timeframe.

This technique is one of the un-sung advantages of LogShipping / TLog
Backups

Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
Benchmark your query performance
http://www.SQLBenchmarkPro.com

"Nasif" <nasif4003@gmail.com> wrote in message
news:3a707c47-85d0-40e1-abdc-4ed1df7998b8@i72g2000hsd.googlegroups.com...
> On Feb 6, 3:26 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>> Nasif
>> How about restoring the database with a different name and then transfer
>> the
>> table's data. Think about , if the table has relationship with ohters
>> tables that get updated and you just bring the data from the past. Is it
>> possible that you get inconsistent data?
>>
>> "Nasif" <nasif4...@gmail.com> wrote in message
>>
>> news:f9aa03a1-26fa-4aed-8628-378a31355b72@m62g2000hsb.googlegroups.com...
>>
>> > Hello All
>>
>> > I am currently doing a project on MS SQL Server 2005 where I am in
>> > need of table level backup/restore. I know about FILEGROUP. But in
>> > our project using FILEGROUP is not feasible. As far as I know MS SQL
>> > Server 2005 does not support Table level restore directly. Moreover
>> > relational integrity is also matter.
>>
>> > Is there any clever trick or 3rd party free software to do table level
>> > restore/backup? Please Help.
>>
>> > Best regards
>> > Nasif
>
> Dear Uri,
>
> Thanks for ur answer. But still there is an overhead to restoring
> whole database. Can u recommend another technique or any 3rd party
> software?
>
> Best Regards
> Nasif

Only possible solution, or half of the solution is to keep the table
in a seperate filegroup and restore that group only.

Its not feasible to keep each table in a single filegroup I agree,
however what can be done is all related tables can be segmented into
their own filegroup, this way DBI is retained if the TX are filegroup
specific.

vips