Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kiranmurali
Yak Posting Veteran
55 Posts |
 Posted - 2012-01-11 : 01:26:05
|
| Hi All,i wanted to generate the script for my development database daily.i just wanted to know whether i can run a job on daily basis to generate the script automatically for the specified time.can any one help me to solve this senario.Thanks in Advance,kiran murali |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-11 : 02:16:51
|
| what all things you want to script out?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
kiranmurali
Yak Posting Veteran
55 Posts |
Posted - 2012-01-11 : 02:19:26
|
| all the store procedures ,functions,views,tables with data. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-01-11 : 05:29:20
|
quote:
all the store procedures ,functions,views,tables with data.
Isn't that just a backup?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
kiranmurali
Yak Posting Veteran
55 Posts |
Posted - 2012-01-12 : 02:48:25
|
| yes,its just a backup.regards,Kiran Murali |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-12 : 03:12:46
|
| then isnt it better to add a job which takes a backup and schedule it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-01-12 : 03:13:50
|
| You can run a job that executes a procedure which takes backup and store it in the hard diskMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
DAILY JOB