Home Forums SQL Server 2005 SQL Server Newbies any document on Moving databases from One Server to another RE: any document on Moving databases from One Server to another

  • Grant Fritchey (3/16/2010)


    What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?

    Backup and restore would be my first inclination for users databases. However, if they are moving from SQL 2K to SQL 2K8, there are some other nuances to be addressed (dts, ssis, jobs) that would be different.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events