Restoring specific db objects 
Author Message
 Restoring specific db objects

Hi,

I have read (in BOL) that it's possible to restore only
selected objects by using filegroups. Theoretically if I
follow that train of thought; doesn't that mean that all objects
needs to be placed in its separate filegroups ?

Is there a more transparent way of restoring only selected objects
( a table or sproc ) individually ? An incident happened recently whereby
a table in my application got corrupted.

I am using a backup script (tsql of backup commands) that's being scheduled
by sql agent on sqlsvr7.0

--
Regards,

Gavin Bong



Thu, 05 Dec 2002 03:00:00 GMT
 Restoring specific db objects

 Gavin-  you are correct, and there is no other way around it...

 > I have read (in BOL) that it's possible to restore only

Quote:
> selected objects by using filegroups. Theoretically if I
> follow that train of thought; doesn't that mean that all objects
> needs to be placed in its separate filegroups ?

> Is there a more transparent way of restoring only selected objects
> ( a table or sproc ) individually ? An incident happened recently whereby
> a table in my application got corrupted.

> I am using a backup script (tsql of backup commands) that's being scheduled
> by sql agent on sqlsvr7.0

> --
> Regards,

> Gavin Bong

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (428 entries) see
 forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)
 or www.ntfaq.com/sql.html
 or www.sql-server.co.uk
 or www.mssqlserver.com/faq


Thu, 05 Dec 2002 03:00:00 GMT
 Restoring specific db objects
you could always restore the backup to a new database and DTS the objects
you need... done that a few times.

jaime

Quote:
> Gavin-  you are correct, and there is no other way around it...

>  > I have read (in BOL) that it's possible to restore only
> > selected objects by using filegroups. Theoretically if I
> > follow that train of thought; doesn't that mean that all objects
> > needs to be placed in its separate filegroups ?

> > Is there a more transparent way of restoring only selected objects
> > ( a table or sproc ) individually ? An incident happened recently
whereby
> > a table in my application got corrupted.

> > I am using a backup script (tsql of backup commands) that's being
scheduled
> > by sql agent on sqlsvr7.0

> > --
> > Regards,

> > Gavin Bong

>  Neil Pike MVP/MCSE.  Protech Computing Ltd
>  (Please reply only to newsgroups)
>  SQL FAQ (428 entries) see
>  forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(sqlfaq.zip - L7
> - SQL Public)
>  or www.ntfaq.com/sql.html
>  or www.sql-server.co.uk
>  or www.mssqlserver.com/faq



Fri, 06 Dec 2002 03:00:00 GMT
 Restoring specific db objects
Hello,

Create temporary  database  and try . From the temp datbase use dts to
import selected  tables .


Quote:
> Hi,

> I have read (in BOL) that it's possible to restore only
> selected objects by using filegroups. Theoretically if I
> follow that train of thought; doesn't that mean that all objects
> needs to be placed in its separate filegroups ?

> Is there a more transparent way of restoring only selected objects
> ( a table or sproc ) individually ? An incident happened recently whereby
> a table in my application got corrupted.

> I am using a backup script (tsql of backup commands) that's being
scheduled
> by sql agent on sqlsvr7.0

> --
> Regards,

> Gavin Bong



Tue, 17 Dec 2002 03:00:00 GMT
 Restoring specific db objects
The only safe way I have used is to restore from backup to a new
temporary database on some spare disks and then use t-sql to copy the
table needed across then delete the temporary database. In fact I keep
60Gb of scratch space just for this purpose!

Ian



Quote:
> Hello,

> Create temporary  database  and try . From the temp datbase use dts to
> import selected  tables .



> > Hi,

> > I have read (in BOL) that it's possible to restore only
> > selected objects by using filegroups. Theoretically if I
> > follow that train of thought; doesn't that mean that all objects
> > needs to be placed in its separate filegroups ?

> > Is there a more transparent way of restoring only selected objects
> > ( a table or sproc ) individually ? An incident happened recently
whereby
> > a table in my application got corrupted.

> > I am using a backup script (tsql of backup commands) that's being
> scheduled
> > by sql agent on sqlsvr7.0

> > --
> > Regards,

> > Gavin Bong

Sent via Deja.com http://www.deja.com/
Before you buy.


Tue, 17 Dec 2002 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Restore DB from transaction log to specific date

2. SQL 6.5 DB Restoring vs SQL 7.0 DB Restoring

3. trouble restoring a DB, trouble deleting half-restored DB

4. send specific oracle 8i table data to specific sql server 2000 table at specific times

5. restoring db using sqldmo object in sql server7.

6. after dump/restore all objects req db.table.elem instead of table.elem

7. Restoring a specific tables

8. attempt to restore, said db was dumped under diff sort order, how to restore it

9. Restoring specific tables and table segments in INFX 7.2

10. Restore a specific table or database...HOW?

11. Transaction Log vs restore at a specific point in time

12. Restore trouble, how to restore DB-users????


 
Powered by phpBB® Forum Software