General Discussion - Sql Server Backup

Print Page | Close Window

Sql Server Backup

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21857
Printed Date: 29 March 2026 at 7:00pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Sql Server Backup

Posted By: suedechaser
Subject: Sql Server Backup
Date Posted: 07 November 2006 at 6:42am

Hi all,

Does anyone have a hint for a program to download a backup of a SQL Server db/data to my own PC from a SQL Server db provided by an ISP.

I thought I found a good one in EMS Lite ( free ) but only good for modifying. If the same program does MySql, that would be even sweeter.

thankyou

regards

suede

Replies:

Posted By: dj air
Date Posted: 07 November 2006 at 9:48am

if you want a MSSQL Dump, most isp's will give you a .sql file on request.

usually place the file above the domain(s) root for downloading

else if you have the MSSQL tools and full access over the Database you should be ok,

if you are running a MSSQL server locally, you could use access to connect to the remote SQL server and export the tables to your local server into a blank SQL database, then use a Back up of that

Posted By: suedechaser
Date Posted: 14 November 2006 at 3:25am

Hi DJ,

Sorry for not responding sooner.

I have full access over the DB - ie I can access and add tables, fields etc.
What are MSSQL tools? Do these allow me to download a backup of s MSSQL DB from my ISP's server.
They can do occasional dumps, but I am looking for a backup solution that allows me to, say, download a backup every few days.

Is this kind of thing possible to do remotely from my PC?

regards

suede

Posted By: iSec
Date Posted: 14 November 2006 at 3:38am

Enterprise Manager allows you to connect to your ISP's server where the db is placed assuming that your credentials are valid and you can login...

EM is part of Microsoft SQL, you can download a free trial (fully functional) from microsoft, install it, then connect to your host, browse your db, right-click on it and use the import/export...

The link to download the MSSQL Evaluation is: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=D20BA6E1-F44C-4781-A6BB-F60E02DC1335 - http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=D20BA6E1-F44C-4781-A6BB-F60E02DC1335

P.S. when you install it, it will put a folder on your C drive... from there you open the folder and excute the setup.exe file... so it is kind of two steps installtion.

I'm at work now having a short break, i'd have provided more details on how to import/export..but give this a try and let us know how it goes..

-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard

Posted By: suedechaser
Date Posted: 14 November 2006 at 4:36am

Hi Info Tech,

Thank you for this link. This is for a full version of MSSQL - correct? Not just for Enterprise Manager?
If so, I think I know someone with a new, full version of MSSQL Server - do later versions still have Enterprise Manager installed, or do I need to download the 2000 version in your link?

regards

suede

Posted By: iSec
Date Posted: 14 November 2006 at 5:28am

Yes, it is the full version of MSSQL.

The later version should, i'm not sure. I have always liked EM in sql 2000... and if your database is currently sitting on a 2000 sql server then it is recommended that you use the 2000 version to back it up.

-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard

Posted By: suedechaser
Date Posted: 14 November 2006 at 10:25pm

After 8 hours 13 mins, I have downloaded the 2000 version...phew.

I will have a go at install after work.