I've been beating this horse for too long now ... I need some professional help (read you).
Using SQL Server Management Studio I can successfully connect to the remote server and execute queries, create the database by executing the script created from Tasks -> Generate Scripts and selecting the database (Schema Only) ... then running that script on the remote machine (all good) ... it is the data that is giving me the problem.
The problem I'm having is that when I try to restore the database on the remote server using SQLSMS (Tasks -> Restore -> Restore Database) the dialog where I specify the file is in the context of the remote database ... where I do not have permission to access the file system to find the .BAK file. When I continue on and try to enter the local location of the file, the same problem raises its head. I cannot get the .BAK file to the remote server and I cannot get the remote server to recognize my local file system containing the .BAK file.
Hence, I'm oh so stuck.
Thanks guys and gals,
CT