August 12, 2003 at 3:44 pm
I have need for a workstation application to get a copy of a database running on a server. The workstation has no file-access rights to the server. How can I get a local copy of the DB (which could be 200 MB)? The application will have DB administrator rights on the server. It was suggested to use some form of DTS, but in my experience, there is always something that fails when attempting to "Export" a db from one server to another.
August 12, 2003 at 7:05 pm
How about getting the server to BACKUP DATABASE either to a share on the workstation, or to an alternative commonly-accessible share?
Cheers,
- Mark
Cheers,
- Mark
August 13, 2003 at 9:03 am
Can I backup to a non-local drive? Obviously, using T-SQL could be different, but when testing with E.M., I could not specify anything that was not on the local machine.
August 13, 2003 at 9:09 am
Yes, you can back up non-locally, as long as the SQL Server login can see the data space. Your command would be something like:
BACKUP DATABASE MyDB TO DISK = '\\Data4\BackupSQL\WEB\MyBackup.dat' WITH INIT,SKIP
August 13, 2003 at 10:28 am
sadly, even if I can backup to a file-share using T-SQL, which I think I verified, but ran into the same problem I will have when installed on-site for a user, I don't think this solution will fly with our network security gurus. They're paranoid about the SQL server having file access to any other machine. So, again, I'm back to DTS. Has anybody out there tried this?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply