Click here to Skip to main content
14,880,257 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
I have microsoft sql server management studio 2008, and I have a question regarding it, that how can we generate script (which can be saved in .txt format file) of the database name "login".

It is for purpose that some times my system crashes and hence by generating script it will help me to regenerate my database again from that hazard.

Plz give only steps what to click and next. Thankx in advance
Posted

1 solution

1) You can use the script wizard. http://www.mssqltips.com/sqlservertip/2500/sql-server-2008-r2-generate-scripts-wizard-with-database-schema-and-data/[^]
2) A backup strategy would be more appropriate to handle such scenarios.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900