Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backup database tables but no data
Message
 
To
02/09/2004 11:08:13
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
00938774
Message ID:
00938781
Views:
12
Don't you just want to script your database?

From Enterprise Manager:
-Right click your database
-Select "All tasks"
-Select "Generate SQL Script..."



>Hello,
>
>How do I backup the database + stored procedures + triggers but not the data in a database?
>
>I am currently using SQL 2000
>
>Thank You.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Reply
Map
View

Click here to load this message in the networking platform