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 |
|
SQLCode
Posting Yak Master
143 Posts |
 Posted - 2008-07-21 : 09:37:39
|
| Hi,I have a back up file of about 65 G for a 120 G db. It is giving us problems moving. But the problem is that it is moving fine within the Server. When moved across the servers, it comes back with insufficient resources or path too deep or some wierd problem. We have bigger dbs and don't have any problem moving those.The network team blames it on db, to be problematic. I ran dbcc and one of the very big archive tables had consistency error on an index. I dropped that index, moved a lot of data from that table to an alternate location (as a backup). Ran the dbcc again without any erros. I also shrank the db. Took a fresh back up. It still gives 'Insufficient resources' error. But the destination has a lot (300+ G)of space available. Any suugestions on this? What must be the problem?We had been getting a lot of I/O errors on this db. So we took this db and trying to move to a new set of servers (cluster) and even new network.Please help! Where might be the problem be? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-21 : 11:24:34
|
| Never had this issue.See if this helps:http://www.sqlservercentral.com/Forums/Topic517151-357-1.aspx#bm517775 |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2008-07-21 : 15:42:05
|
| Cannot copy mydb: Not enough server storage is available to process this command. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-21 : 15:45:47
|
| According to the Google search results, it looks to be an OS error. Google this: "Cannot copy Not enough server storage is available to process this command" for resolutions. Remove the double quotes though when searching. I put them in my post to indicate the beginning and ending phrase to search on.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2008-07-21 : 15:49:08
|
| Thanks Tara, but why just this db. Others are doing fine. I will also search google. Thanks for all the help and advice. |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-07-21 : 18:44:20
|
| Have a look at MS KBarticle 304101. I've run into this a few times moving files around the network.You're basically running the kernel (OS) out of pageable memory space trying to copy the files. The article demonstrates how to change the value at what point the kernel starts swapping out memory.Your friendly High-Tech Janitor:http://grayburn.wordpress.com |
|
|
|
shafi.spl
Starting Member
10 Posts |
Posted - 2008-07-26 : 02:49:00
|
| i never face |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Moving back up files