Monday, March 19, 2012

Back up for SQL Server

Hi,
For Asp.net project i have used backend as sql server database.My database name is Traveldb.i want to take the backup for this database in SQL Server as a "Filename.sql".
Please tell me the steps to follow to take the backup file as SQL Script File extension.
Thanks & Regards,
Laxmi

I'm curious as why you want to back up the database that way. It would be much more efficient to backup the database using the built in backup functions. I don't know of any tool that you could use to backup the data into a SQL Script although Enterprise Manager will allow you to script the database definition (i.e. the tables, stored procedures, views, indexes and so on)

No comments:

Post a Comment