Forum Replies Created

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

  • RE: Scenario

    Also, whenever you restore databases, you typically run into "Orphaned Users" (mismatch between

    Logins and Users)

    EXEC sp_change_users_login 'update_one','login','user' to fix that.

    http://www.akadia.com/services/sqlsrv_logins_and_users.html%5B/url%5D has some info on it

  • RE: Scenario

    yes exactly...you shouldnt be making modifications to the Master database.

    1) DTS has Transfer Logins & Transfer Stored Procs tasks. Look into that.

    2) you could copy the .MDF and .LDF...

  • RE: Brand New SQL Server

    Having a separate physical disk for OS, Data, Logs and Backups make sense.

    But a separate disk for tempdb seems like overkill..

    I suppose it depends on what you are doing with...

  • RE: Backup will not complete

    Have you checked the SQL SERVER Logs?

    perhaps you are hitting a file size limit? or a limit on the number of files?

    Is it a DTS task that is waiting on...

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