SQL - Create Backup

O

OJM

Perch
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
 
OJM, you can't actually do anything with DB there that is backed up :)

You need to do it via the web interface or ticket.
 
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
 
Re: SQL Create Backup

I would recommend using a tool like sqlyog and doing an import from your machine into SQL server.
 
You must log in or register to reply here.
Back
Top