How to create DB Dump in MSSQL2005?

[AccessTest]

Hi Guys

I need your help, i would like to create a DB dump for a current DB
that i have. The DB is MSSQL 2005, i will be happy to hear directions.

Thanks for your time

 

[SQL_Hell]

open a new query in management studio and type the following


backup database mydatabase to disk = 'd:\mydatabase.bak' with init

change the word mydatabase to thje name of your database and change
'd:\mydatabase.bak' to the path and filename you want

 

[AccessTest]

That works perfect! Cheers

That works perfect! Cheers

 

[supmktg]

SQL Server 2000 db backup?

I need to move a SQL Server 2000 database from one hosted (via IP login) server to a different hosted (via IP login) server. It seems as though I am unable to backup to any location but the host's server. I have tried copying all objects using DTS, but it fails after transfering the table structure. No data, no views, no indexes, etc.

Both servers are shared, and contain several dozen databases. I'd like to backup my database to my computer, or to an FTP. Is there any way of doing this?

Thanks,
Sup

 

[SQL_Hell]

how are you trying to back to the other server, UNC path?

Are these machines in the same domain? is there a firewall issue?

Why dont you just backup to the host server, then FTP the .bak file across?

 

[supmktg]

SQL Hell,

These are "hosted" servers (different domains) and I don't have the permissions to backup to their server and then get in to FTP.

I just tried a UNC path to my FTP on the new domain and it almost worked, at least it recognized the UNC, but I think it failed because my FTP on that domain is not anonymous and I don't have a way to enter user/password.

Any other suggestions?

Sup

 

[SQL_Hell]

If they are hosted and you don't have access then you must speak to the people who do have access (i.e. the hosting company) and either get access or get them to backup and FTP the file to you.

This is not really a SQL problem, it is an acesss problem you have with your hosting companies

 

[supmktg]

Thanks, their support dept is a pain to deal with, which is why I'm switching hosts. I'll try getting them to backup and FTP to me, I'm sure they won't grant me direct access.

Sup