Home Forums SQL Server 2005 Administering Restoring a DataBase in another SQL Server RE: Restoring a DataBase in another SQL Server

  • August 29, 2015 at 9:01 pm

    #1823242

    alessandro.feltrin (8/29/2015)

    [font="Arial"]

    I don't use Windows authentication but SQL "sa" authentication, so i this case there should be no problem i feel. So, i should be able to restore my original DB also using Enterprise Management Studio ... If you suggest that it should be better to use T-SQL i have to find some appropriate script in order to submit a query ...

    Alessandro

    [/font]

    I strongly recommend that you change your application to use a least-privilege login. It most likely only needs permission to execute procedures, and possibly data reader / data writer access.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2