Link to home
Start Free TrialLog in
Avatar of manivineet
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.
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

Avatar of manivineet
manivineet

ASKER

nope. I already explored that 1
Some better ideas please.
ASKER CERTIFIED SOLUTION
Avatar of marat-oz
marat-oz
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thnkx