Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 backup from a remote database server?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

badua
Starting Member

22 Posts
Posted - 10 November 2004 :  02:35:07  Show Profile  Send badua an ICQ Message
How can I backup a whole database from a remote MS SQL2000 server that I am subscribing?

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 10 November 2004 :  05:15:26  Show Profile  Send ruirib a Yahoo! Message
Do you have access to the server, through, say Remote Desktop Connection or similar? Cause if you don't, I don't think you will be able to do it.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Podge
Support Moderator

Ireland
3776 Posts
Posted - 10 November 2004 :  06:43:07  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Do you have Enterprise Manager installed?
If you have MSDE on a local machine you could backup to there.

I know of one online company that does it for you - http://www1.ahsay.com/en/solution/backupExpress.htm
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

badua
Starting Member

22 Posts
Posted - 11 November 2004 :  04:08:03  Show Profile  Send badua an ICQ Message
Of course, after subscribing I received server IP address, port, user and password to access.

I use them to export my database from local Enterprise Manager. Everything is OK. But when I'd like backup a whole from remote server, I also use Import data (Copy objects and data between SQL databases), then encounter error: Server user is not a valid user in database 'eforms'

How do I deal with the problem?
or any other ways to retrieving my database
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 11 November 2004 :  04:18:23  Show Profile  Send ruirib a Yahoo! Message
Have you talked with your server admin? He should fix that issue for you.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 11 November 2004 :  17:01:43  Show Profile  Visit Gremlin's Homepage
quote:
then encounter error: Server user is not a valid user in database 'eforms'
Create the local account "server" on the installation your exporting too.
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07