in

Dotnetpanel Forums

Community support forums for DotNetPanel products
Dotnetpanel Forums » Web Hosting » Windows Administration » Moving whole SQL 2008 database (not single DB but engine with all databases) to another host

Moving whole SQL 2008 database (not single DB but engine with all databases) to another host

Last post 04-05-2010 11:27 AM by Vikas Sonawane. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 06-18-2009 12:17 PM

    • GrZeCh
    • Top 10 Contributor
    • Joined on 04-25-2007
    • Poland
    • Posts 651

    Moving whole SQL 2008 database (not single DB but engine with all databases) to another host

    Reply Contact

    Hello,

    does anyone know what is the best way to backup whole SQL 2008 engine with all databases and move it to another host?

    Thanks

    DotNetPanel 2.8.14

  • 07-23-2009 1:27 AM In reply to

    • Rubal
    • Top 10 Contributor
    • Joined on 03-16-2006
    • India
    • Posts 838

    Re: Moving whole SQL 2008 database (not single DB but engine with all databases) to another host

    Reply Contact

    Are you looking for a server migration or export / import of all dbs on a machine where few or more databases already exists?

     

    Rubal Jain // Email - Rubal @ Rubal [dot] Net

    Windows Server Setup, Configuration, Troubleshooting, Basic Security & Hardening
    DotNetPanel - Helm Control Panel Setup, Installation, Configuration, Troubleshooting

    Authorised DNP Reseller. Get 20% Discount on all DNP Licenses.
    Authorised SmarterTools, Declude, SimpleDNS (JHSoft), Gene6 FTP, Helicon, Kayako, Icewarp Merak, MailEnable, Deerfield Reseller.

    DotNetPanel & SmarterTools Monthly Leased Licenses available.

    DotNetPanel Professional Server setup includes installation of PHP, Perl, Python, ASP.Net Frameworks, SQL Express, MySQL, SmarterMail, Stats etc and complete integration with control panel just $199/server. Contact for further details.

  • 04-05-2010 11:27 AM In reply to

    Re: Moving whole SQL 2008 database (not single DB but engine with all databases) to another host

    Reply Contact

     @GrZeCh

    If I understood your query,  you would like to migrate MSSQL 2008 database server along with User-name/Passwords. Yes, it is possible with help of following steps,

    1] Installed MSSQL 2008 server on new server with same path [ Data files (.MDF and .LDF)  path would be same on new server  ]
    2] Copy All MDF and LDF files along with Master database from old server to new server.
    3] Restart MSSQL service on new server.

    All database would be attached automatically with same user-name and password.

    I hope this will help you.

    Cheers !!

    Vikas Sonawane.

    Sr. Windows System Administrator.
    MCP, MCSE, CCNA
Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems