Try asking them here.
http://www.microsoft.com/communities...&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
|

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
|