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 |
|
notshai
Starting Member
8 Posts |
 Posted - 2011-09-01 : 09:39:17
|
| -sql08 r2 installed on C drive.-created a DB with data files located on a USB drive.-trying to restore a 28GB backup onto the DB.~i get a size out of space error for the C drive.why is it concerned about the C drive space if the DB files are on the UBS?is it staging the data on C drive first?or is a DB on USB not supported? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-09-01 : 10:01:22
|
quote:
or is a DB on USB not supported?
No it's not supported, since the drive can be disconnected at any time and prevent SQL Server from cleanly shutting down databases on that drive. This could lead to irreparable data corruption. Only put database files on internal drives or storage-area networks (SANs). |
 |
|
|
notshai
Starting Member
8 Posts |
Posted - 2011-09-01 : 11:23:32
|
| but why does it let me create a DB on the USB drive if its not supported?this is obviously not for production, its for a dev server, we ran out of space...is there any way around this restriction? (mounting software etc?) |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-01 : 11:26:23
|
| Trace flag 1807 will allow it, but it is NOT a good idea. Better to add disks.May want to read this article |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2011-09-01 : 13:49:15
|
| How did you restore? Can you put down all the steps? |
|
|
|
|
|
|
DB files on USB drive, restore fails.