Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wardsan
Starting Member
48 Posts |
 Posted - 2005-07-06 : 06:50:19
|
| Folks,is there any way to do something like this. I want something like a dump file that is produced after exporting an oracle schema. It is for backup purposes. It's for the event when a table is lost, I don't want to have to restore the whole database. We have a database currently 30GB. The bulk of it is images which have their own filegoup, the rest being data and indexes which also have their own filegroups. If I lose a data table, I don't want to have to restore the whole lot. I have never tried restoring a filegroup only. Is there an easier way?tiaSandra |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-06 : 08:52:29
|
| Sandra,of course you can do Export and Import like you do with Oracle databases and depending of your recovery model you can also perform point in time recovery.For that you need to have Full Database backup and a strategy for the backup of your transaction log.Please refere to BOL for Backup,Restore-recovery and for Import-Export.Franco |
 |
|
|
wardsan
Starting Member
48 Posts |
Posted - 2005-07-06 : 08:56:22
|
| Franco, I don't want to do a backup, I want to do an export so I can recover one table if I need to. I have generated bcp statements using sysobjects but now I have another problem, I don't know the command to spool these bcp statements to a file. I want to run this file overnight. Can anybody help? I know I could use 'Results to File' in the query analyzer if i was doing it interactively but as I said, I want to do it in batch. |
|
|
|
wardsan
Starting Member
48 Posts |
Posted - 2005-07-06 : 09:27:13
|
| sorry I was being stupid about writing to file, got it now. |
|
|
|
|
|
|
Oracle style importing and exporting of tables