| Author |
 Topic Search  Topic Options
|
suedechaser 
Groupie
Joined: 25 February 2006
Location: USA
Status: Offline
Points: 129
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Sql Server Backup
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
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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,
OR
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
|
|
suedechaser
Groupie
Joined: 25 February 2006
Location: USA
Status: Offline
Points: 129
|
Post Options
Thanks(0)
Quote Reply
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
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
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...
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
|
|
suedechaser
Groupie
Joined: 25 February 2006
Location: USA
Status: Offline
Points: 129
|
Post Options
Thanks(0)
Quote Reply
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
Edited by suedechaser - 14 November 2006 at 4:44am
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
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
|
|
suedechaser
Groupie
Joined: 25 February 2006
Location: USA
Status: Offline
Points: 129
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
