Environment: Shared Hosting
- No MSSQL control panel
- Only have mssql management studio
MSSQL Server: Remote
- YES Remote SQL Connections
- NO FTP
- NO Shared Drive
Is there a way to backup MSSQL 2005 or 2008 databases to my local machine or shared server? Ive read and tried Microsofts SMO code base and it looks like it backs the files up to the SQL server or shared drive only. Backup type im looking to make is a .BAK type.