February 16, 2009 at 2:16 pm
Hello All,
I have recently started my carrier as a jr DBA and trying to understand and learn the scripts written for Backups, restores, index defragment etc. I would like to know where can I start to learn this scripting? Iam very much interested to know this scripting as soon as possible.
February 16, 2009 at 2:41 pm
You can use the GUI to run a backup or restore, but instead of clicking the final "OK", choose "Script to new window". This will generate the code that SQL runs, so you can see what your GUI options would have run.
February 16, 2009 at 10:06 pm
There are also numerous scripts here on this site for backups that you can go through, see how they work, experiment, etc.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy