how to backup MSSQL database to local Machine?

E

eko

Perch
Before I engage in using mssql2 server, I would like to know how I can get a backup to my local machine, as I don't see any .dbo files becuase one cannot ftp to the mssql2 server.

Please help!
 
An easy way would be to run SQL Server on your home PC. Using Enterprise Manager you could then connect to the SQL database and copy all the data to your home database.

Cameron.
 
cameron said:
An easy way would be to run SQL Server on your home PC. Using Enterprise Manager you could then connect to the SQL database and copy all the data to your home database.

Cameron.
Click to expand...

I think you can also accomplish this by installing just the Client Tools supplied with MS SQL Server, in case you don't want to (or can't) install the entire server package. Key words here are "I think you can".
 
You must log in or register to reply here.
Back
Top