SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    Jul 2010
    Posts
    9
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Move ASP website with MSSQL

    Hello,

    I have a website in ASP with MSSQL, which I want to move to another server.

    I have moved the files but I dont know how to move the database.

    Can anyone help. Thanks.

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,266
    Mentioned
    115 Post(s)
    Tagged
    1 Thread(s)
    If you have enterprise manager/management studio access to both (or have a support equivelant for both), the easiest way is to do a backup/restore on each box.

    Otherwise, there'll be a lot of scripting in your future....
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse

  3. #3
    SitePoint Member
    Join Date
    Jul 2010
    Posts
    9
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can you send me the link of this software ?

    Thanks.

  4. #4
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,266
    Mentioned
    115 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by schwarzes View Post
    Can you send me the link of this software ?

    Thanks.
    It's part of the sql server installation - if you don't know what it is, I would doubt you have direct access to your sql server instance.

    Contact your two hosts (old one and new) about what you need and see if they'll help - it will typically cost extra, but it can help.
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse

  5. #5
    SitePoint Guru
    Join Date
    Jun 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by schwarzes View Post
    Hello,

    I have a website in ASP with MSSQL, which I want to move to another server.

    I have moved the files but I dont know how to move the database.

    Can anyone help. Thanks.
    Moving a database is not an ASP issue. Please move this question to the database forum.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •