Back Up Structure - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Back Up Structure

Author

Topic

DavidKennedy
Starting Member

2 Posts

Posted - 2005-05-05 : 06:17:38

Hi,
I am a beginner at sql server 2000.
Can anybody tell me how to back up the structure of Tables,Views,Stored Procedures and DTS Packages?
I dont need to back up the data,just the structure of the database.

Any help would be greatly appreciated

Thanks in advance
David Kennedy

vijayakumar_svk
Yak Posting Veteran

50 Posts

Posted - 2005-05-05 : 06:25:13

Generate a script using Enterprise Manager "Generate SQL script" option.

-VJ

Work smarter not harder take control of your life be a super achiever

DavidKennedy
Starting Member

2 Posts

Posted - 2005-05-05 : 06:41:46

Thank you,

The script works for everything except the DTS packages.
Is there a different procedure for backing up these packages?

Thanks again,
much appreciated,

David Kennedy

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-05-05 : 17:26:46

Use the save as option to save it to a file. Or just backup the msdb database.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources