Re: SQL server 2000 database remoting copy?

Discussion in 'Microsoft Windows 2000 Applications' started by Dave Patrick, Jun 13, 2005.

  1. Dave Patrick

    Dave Patrick Guest

    Try asking them here.
    http://www.microsoft.com/communitie...cac-defa-4a7f-878e-4df08a7589cb&lang=en&cr=US

    --
    Regards,

    Dave Patrick ....Please no email replies - reply in newsgroup.
    Microsoft Certified Professional
    Microsoft MVP [Windows]
    http://www.microsoft.com/protect

    "williamwon" wrote:
    |
    | I know SQL can copy local database, but
    | I don't find SQL can copy remoting database in a second.
    | Can you help me?
    | I hope I can realize the mirror between local database and remoting
    | database.
    |
    |
    | --
    | williamwon
    | ------------------------------------------------------------------------
    | williamwon's Profile: http://www.msusenet.com/member.php?userid=1841
    | View this thread: http://www.msusenet.com/t-1870531049
    |
     
    Dave Patrick, Jun 13, 2005
    #1
    1. Advertisements

  2. Dave Patrick

    Dave Patrick Guest

    Glad to hear it's sorted.

    --
    Regards,

    Dave Patrick ....Please no email replies - reply in newsgroup.
    Microsoft Certified Professional
    Microsoft MVP [Windows]
    http://www.microsoft.com/protect

    "williamwon" wrote:
    |
    | Dave Patrick,
    |
    | I love you so much.The web address you give me is helpful to me.
    | Following is the good help I give for everyone.
    |
    | 1. Have a common OS user in both systems, Say name of the OS user is
    | backupuser.
    |
    | 2. Start the MSSQL Server and SQl Agent service using backupuser
    | How to do that:
    |
    | So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
    |
    | service-- Double click and select the "Log on" option. There you give a
    | the
    | backupuser
    | and password to start the service. Now stop and start the MSSQL
    | Serevr
    | service.
    |
    | 3. Give the necessary privileges (write) in the remote machine
    | directory and share.
    |
    | 4. After this you try to execute the Backup database command in
    | Query
    | Analyzer:-
    |
    | Backup database <dbname> to
    | Disk='\\RemoteServername\share-\folder\dbname.bak' with init ( With
    | init
    | will
    | overwrite the backup file every time)
    |
    |
    | --
    | williamwon
    | ------------------------------------------------------------------------
    | williamwon's Profile: http://www.msusenet.com/member.php?userid=1841
    | View this thread: http://www.msusenet.com/t-1870531049
    |
     
    Dave Patrick, Jun 23, 2005
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Nav

    SQL Server 7 Enterprise...

    Nav, Jul 1, 2003, in forum: Microsoft Windows 2000 Applications
    Replies:
    0
    Views:
    511
  2. Bruce

    SQL 7 on Windows 2003 Server

    Bruce, Oct 17, 2003, in forum: Microsoft Windows 2000 Applications
    Replies:
    0
    Views:
    202
    Bruce
    Oct 17, 2003
  3. bettervssremoting

    A Comparison of SourceOffSite, SourceAnyWhere and VSS Remoting

    bettervssremoting, Mar 2, 2005, in forum: Microsoft Windows 2000 Applications
    Replies:
    0
    Views:
    252
    bettervssremoting
    Mar 2, 2005
  4. Dave Patrick

    Re: SQL 2000,can you get update records from transcation log?

    Dave Patrick, Oct 20, 2005, in forum: Microsoft Windows 2000 Applications
    Replies:
    0
    Views:
    329
    Dave Patrick
    Oct 20, 2005
  5. Dave Patrick

    Re: SQL Server 2000,how can I find and open transcation history?

    Dave Patrick, Oct 20, 2005, in forum: Microsoft Windows 2000 Applications
    Replies:
    0
    Views:
    407
    Dave Patrick
    Oct 20, 2005
Loading...

Share This Page