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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-28 : 08:17:53
|
| Tony writes "I would like backup the complete structure of a database. Basically backup the database without the data. Somewhat unusual but this type of backup would simplify creating and maintaining a disaster recovery site for nightly load process without encurring all the over head of any form of replication. I appreciate any help you can give.Thanks,Tony" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-28 : 08:18:44
|
quote:
Somewhat unusual but this type of backup would simplify creating and maintaining a disaster recovery site for nightly load process without encurring all the over head of any form of replication
How about just a regular backup? You get structure AND data, and you don't have to load anything afterwards. |
 |
|
|
martinch
Starting Member
35 Posts |
Posted - 2005-01-28 : 10:10:18
|
Well, I'm not sure how to do it under SQL Server, but in MySQL you used to be able to get the table create statement (and thus rebuild the table by using the "source" command) by using SHOW CREATE TABLE. I don't know how to do it under SQL Server though, as it doesn't support SHOW  . I can't find anything useful in the BOL though. Perhaps one of the more experienced members will be able to help you  |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-28 : 22:26:56
|
| Well, strangely enough, looking under "BACKUP DATABASE" in Books Online yields a wealth of information about...how to backup a database. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-28 : 22:30:04
|
quote:
this type of backup would simplify creating and maintaining a disaster recovery site for nightly load process without encurring all the over head of any form of replication.
Let me know how this works out. EEEEEEEK "simplify"?????Try shipping your logs. You can find it under what Rob said!!!MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Database Backup