PC Review


Reply
Thread Tools Rate Thread

Re: SQL server 2000 database remoting copy?

 
 
Dave Patrick
Guest
Posts: n/a
 
      13th Jun 2005
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
|


 
Reply With Quote
 
 
 
 
Dave Patrick
Guest
Posts: n/a
 
      23rd Jun 2005
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
|


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: Remoting: Passing information to the Remoting Object upon Creation Felix Wang Microsoft C# .NET 3 9th Feb 2004 10:09 AM
Re: Remoting: Passing information to the Remoting Object upon Creation Matthew Wieder Microsoft C# .NET 0 6th Feb 2004 03:01 PM
Re: Remoting: Passing information to the Remoting Object upon Creation Matthew Wieder Microsoft C# .NET 0 5th Feb 2004 02:04 PM
Remoting: Passing information to the Remoting Object upon Creation Matthew Wieder Microsoft C# .NET 0 4th Feb 2004 11:42 PM
How do I tell when a remoting client or remoting server goes away? John Microsoft Dot NET Framework 4 19th Sep 2003 01:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:43 AM.