Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smithsys
Starting Member
2 Posts |
 Posted - 2008-07-30 : 16:55:39
|
| I'm trying to locate my SQL 2000 data and log files in a PGP virtual drive to allow people to travel with real data on their laptops, and only mount the pgp drive when ready to use the database. It sort of works, except when we run big jobs which allocate lots of data and/or log pages. Then it almost always ends with a timeout error (on the SQL Server side) or an error appearing to indicate a hardware problem. Smaller jobs and browsing the database works ok.Has anyone experienced this? Any suggestions? Thanks. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-07-30 : 18:35:54
|
| This doesn’t seem like a good idea, and I doubt Microsoft will support it.You may want to explore using the Encrypted File System, something that SQL Server explicitly supports.CODO ERGO SUM |
 |
|
|
smithsys
Starting Member
2 Posts |
Posted - 2008-07-30 : 21:56:23
|
quote:
Originally posted by Michael Valentine Jones
This doesn’t seem like a good idea, and I doubt Microsoft will support it.You may want to explore using the Encrypted File System, something that SQL Server explicitly supports.Thanks. I'll check it out.CODO ERGO SUM
|
|
|
|
|
|
|
Storing mdf and ldf files on pgp virtual drive