Post reply

Generate Scripts after taking the backups.

  • December 19, 2009 at 12:02 am

    #207653

    Hello Experts

    I have the following 2 queries:

    (1)After taking the backup(full) of the database, do I need to mandatorily generate the 'scripts' tp transfer the 'users' and 'roles'?

    (2) While generating the scripts, I found that it asked to generate the schema, views and so on.. How will I come to know what are the mandatory objects which I need to script out?

    If somebody can explain on this would be much helpful.

    Regards

    Sourav

    Thanks.

  • December 19, 2009 at 2:06 am

    #1094422

    you can script out logins from the master database and jobs from msdb database so that in the even of your database getting crashed, you can recover logins and your jobs..


    Pradeep Singh

  • December 19, 2009 at 8:35 am

    #1094450

    Thanks Pradeep.

    Thanks.

  • December 20, 2009 at 6:09 pm

    #1094556

    users and roles are in your database anyway. As Pradeep mentioned, the logins are in master, so you are good if you restore that.

    If you restore the database elsewhere, but not master, you would need a script of logins. I'd recommend you keep one around since you could end up moving this database to another instance in a disaster and might not want to restore master. Search for sp_help_revlogin to script out the logins.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply