sqlserver 2005 installation

  • Hi,

    How to script the jobs/logins from test to production.

    🙂

  • Why don't you download and install SQL Server Express.?

    It's free right..?

  • we have to use the evalution edition only.

    how can i get scripted all the logins andjobs.

    🙂

  • dba-vb (10/5/2009)


    Hi,

    we are using the evaluation edition in our production environement.Now the time elapsed(6 months) how can i re-install? what i need to consider(backup)?How can i get the jobs, logins, ft etc., from the old server.

    please help me.

    First off, you shouldnt be using the evaluation edition on production. I have never been put in this position. if you cannot login to the server, then the only thing you can do is copy the data folder over to another volume, including the system databases. and once you have reinstalled. hopefully with a licensed copy, you can attach the user databases and restore the system databases else where so you can try and script/copy the logins, jobs from there.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • dba-vb (10/5/2009)


    Hi,

    we are using the evaluation edition in our production environement.Now the time elapsed(6 months) how can i re-install? what i need to consider(backup)?How can i get the jobs, logins, ft etc., from the old server.

    please help me.

    Its actually, Illegal if you read the Microsoft EULA 😛 and I wonder the daring to ask such things in the public forums:w00t:

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

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

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