SQL - Create Backup

Customer Support Database Support
1

Hi all,

Does anyone know how to go about creating a .bak file of an MS SQL database?

I’m connecting to an SQL 2000 database using Microsoft SQL Server Management Studio Express, and when I choose to create a .bak file, it only allows me to create it on the server HDDs - interesting, as I can see other backups users have created etc…worrying???

What I’d ultimately like to do is backup my SQL 2000 database to a .bak file, then restore this onto an SQL 2008 server (both at JodoHost), using EMS SQL Manager Lite.

Any ideas?

Cheers,

Oli

2

Send ticket for this.

3

OJM, you can’t actually do anything with DB there that is backed up :slight_smile:

You need to do it via the web interface or ticket.

4

SQL Create Backup

I recently got a second account in valuehost. I want to transfer a table in my database from one account to the other. I first backed up the table using phpmyadmin, then when attempting to restore the table in phpmyadmin, it always times out part of the way through. Its a rather large table, 6MB.

I went to the how-tos and found someone who posted a script where you first FTP the backup file to the server, then run the php script to import - but that times out too.

Anyone got any suggestions?? Thanks

5

Re: SQL Create Backup

I would recommend using a tool like sqlyog and doing an import from your machine into SQL server.