By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,564 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,564 IT Pros & Developers. It's quick & easy.

Help in Table level restore/backup

P: n/a
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
Feb 6 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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" <na*******@gmail.comwrote in message
news:f9**********************************@m62g2000 hsb.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

Feb 6 '08 #2

P: n/a
On Feb 6, 3:26 pm, "Uri Dimant" <u...@iscar.co.ilwrote:
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.comwrote in message

news:f9**********************************@m62g2000 hsb.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
Feb 6 '08 #3

P: n/a
Nasif
How big is your db?

"Nasif" <na*******@gmail.comwrote in message
news:3a**********************************@i72g2000 hsd.googlegroups.com...
On Feb 6, 3:26 pm, "Uri Dimant" <u...@iscar.co.ilwrote:
>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.comwrote in message

news:f9**********************************@m62g200 0hsb.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

Feb 6 '08 #4

P: n/a
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" <na*******@gmail.comwrote in message
news:3a**********************************@i72g2000 hsd.googlegroups.com...
On Feb 6, 3:26 pm, "Uri Dimant" <u...@iscar.co.ilwrote:
>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.comwrote in message

news:f9**********************************@m62g200 0hsb.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

Feb 6 '08 #5

P: n/a

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
Feb 7 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.