I made the mistake of getting involved with a friend who started a hosting business but now I want out. My question is how on earth do I get my MSSQL database off of his server and onto my local drive. I tried doing the backup but that errors out with permission errors. I've tried export data by setting the destination to my local SqlServer and that errors out also with permission errors I assume. when I just generate a sql script it keeps adding my username for the server as the owner of the tables rather than dbo so I have
setuser N 'myusername'
throughout the generated sql script.

Im relatively new to SQLServer and know just about enough to be dangerous and thats it.

Any help would be greatly appreciated.