We have a situation where we are trying setup a test SQL database on
a server.
        The server (WinNT4 w/TSM client 3.7.2 and SQL client 1.1.2 and
MS-SQL 6.5) itself is cramped for space and we need to make a copy of the
database so that we can do some testing and still keep the production
database running. Our database guy says that MS-SQL has a way to dump the
database to a flat file and then you can just import it into a new database.
Unfortunately, he says that you can only dump the file to a drive on the
server itself and not another network drive. The server doesn't have enough
drive space to do the dump on to its self.
        Now the question, can we tell the TDP client to do a restore of the
production database but then redirect it to another server running SQL? We
have a spare server that has plenty of space that can be used for this.
       Thanks

David Tyree
Microcomputer Specialist
South Georgia Medical Center
229.333.1155

Confidential Notice:  This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information.  Any unauthorized review, use,  disclosure or
distribution is prohibited.  If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.