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
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