SQL Server Performance

copy database wizard

Discussion in 'SQL Server DTS-Related Questions' started by rtmurugan, May 19, 2006.

  1. rtmurugan New Member

    i am trying to copy the database from one server to another server which is in the same network using 'Cdw' in the command prompt.
    I get the error "copy failed \(source server name)MSSQL...xxx.MDF "
    I want to copy the databases which are in production server to stand by server
    for emergency. If there are any connections while copying whether it will kill or
    will not copy the database to the destination server.

    Please help...
  2. ranjitjain New Member

    just type "cdw" in command prompt or in run command and then the wizard screen appears.
    Select source and destination server to complete your task and check whether that returns any error or copy/move the objects successfully
  3. satya Moderator

  4. Luis Martin Moderator

    Why not log shipping?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  5. rtmurugan New Member

    i have used 'cdw' in run command only. after choosing source and
    destination servers,databases it gave the error
    "Failed to copy file \(servername)OMWWIZDMSSQLDataxxx.MDF"

    It creates share,detaches the database,closing active connections., etc.
  6. Luis Martin Moderator

    did you check permission in destination?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  7. rtmurugan New Member

    can u please elaborate what permission should i check in the destination server?.
  8. Luis Martin Moderator

    Full permission on destination folder.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  9. rtmurugan New Member

    yes, the user is having administrator previlages and having
    full control. even then it is giving failed to copy error.
  10. satya Moderator

    Can you check permission for the SQLAgent account between the SQL Servers.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  11. rtmurugan New Member

    actually we are going to shutdown the production server temporarily.
    i want to port nearly 500 databases to another server. what is the best method to make another server up with 500 databases with minimal downtime.

    i tried to restore the source server's master database to another server
    in single user mode. the master database is restored successfully but
    the sqlserver service could not be started and i am struck here.

    if i get succeed in starting the service after restoring master database,
    i can restore the msdb database also for all logins and other objects.

  12. rtmurugan New Member

    what is sqlagent account
    i do not have domain environment
  13. ranjitjain New Member

    sqlagent is a service which must be in run mode to fire any jobs.
    Under services.msc check the account by which sqlagent service gets started
  14. satya Moderator

    KBAs to resolve the issue and attach the databases:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
    http://www.databasejournal.com/features/mssql/article.php/2224361

    Information about the orphaned users issue that might come up:
    http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
    http://vyaskn.tripod.com/moving_sql_server.htm

    Also take your time to read Books online about basic information that are needed to understand.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page