Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: How to move files between servers?

    Can I move a database from one server to another server using QA?

    EXEC sp_detach_db @dbname = 'IISLOG'
    EXEC sp_attach_single_file_db @dbname = 'IISLOG',
    @physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\IISLOG.mdf'

    Or would I need a tape backup to move this database to another server?



  2. #2
    Join Date
    Feb 2004
    Detaching, doing a copy and attach is a decent way of moving databases from one server to another. There's a catch though: orphaned users. Each database has a list of users and per user it's permissions on that database. The SQL Server also has a list of users allowed to the server. You might end up with users mentioned in the database that are not in the server's list.

Posting Permissions

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