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 |
|
KHeon
Posting Yak Master
135 Posts |
 Posted - 2003-04-17 : 08:52:41
|
| This may seem odd, but is there anyway to automate a backup of just the table structure, sprocs, triggers, views, etc and not the data? We have a development server that I'm trying to get into a backup rotation that works with our to tape backup schedule but the development server backups are getting pretty large. We don't really care about the data in the databases, just the structure of the tables because we can easily rebuild the data if the need arose.Any thoughts/tips would be much appreciated.Thanks!Kyle HeonPixelMEDIA, Inc.Senior Application Programmer, MCPkheon@pixelmedia.com |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-04-17 : 08:55:18
|
| NR has a nice stored proc that will generate scripts of all your objects via dmo.It can be found at http://www.nigelrivett.com/Scripting via DMOEdited by - ValterBorges on 04/17/2003 08:56:21 |
 |
|
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2003-04-17 : 09:06:13
|
| Many thanks! I'll definetly check that script out.Kyle HeonPixelMEDIA, Inc.Senior Application Programmer, MCPkheon@pixelmedia.com |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-04-17 : 09:11:34
|
| Easily recreate the data?....Need to script all objects every night?What relese procedures do you have? You should know the impact of your objects before you go "live" and should have a copy of what changed anyway.I must be missing something.Brett8-) |
|
|
|
|
|
|
Backing up just table structures, not the data too