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.