manivineet
asked on
how to automate generate scripts wizard MS SQL SEVER
as the title suggests, I want to take a backup of all scripts that are there in the Database (not the DATA, only scripts).
Now i know that this can be done through the Generate Scripts wizard.
I want to know, how can I automate this task. e.g. create it as a JOB that runs daily.
Thanks.
Now i know that this can be done through the Generate Scripts wizard.
I want to know, how can I automate this task. e.g. create it as a JOB that runs daily.
Thanks.
ASKER
nope. I already explored that 1
Some better ideas please.
Some better ideas please.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thnkx
http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en