Help in Table level restore/backup

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.DeleteThis@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
 >> Stay informed about: Help in Table level restore/backup 

Nasif
How big is your db?

"Nasif" <nasif4003 RemoveThis @gmail.com> wrote in message
news:3a707c47-85d0-40e1-abdc-4ed1df7998b8@i72g2000hsd.googlegroups.com...
> On Feb 6, 3:26 pm, "Uri Dimant" <u... RemoveThis @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... RemoveThis @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
 >> Stay informed about: Help in Table level restore/backup 

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.DeleteThis@gmail.com> wrote in message
news:3a707c47-85d0-40e1-abdc-4ed1df7998b8@i72g2000hsd.googlegroups.com...
> On Feb 6, 3:26 pm, "Uri Dimant" <u....DeleteThis@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....DeleteThis@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
 >> Stay informed about: Help in Table level restore/backup 

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
 >> Stay informed about: Help in Table level restore/backup