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 |
|
rbrown2012
Starting Member
3 Posts |
 Posted - 2012-02-17 : 15:55:39
|
| I use Quest LiteSpeed to backup and restore dbs. I've been task to provide some historical data from one particular table. I've successfully been able to recovery the table from a few backup files but then started getting the below error message:LiteSpeed(R) for SQL Server Object Level Recovery 6.5.0.1460Copyright 2011 Quest Software, Inc.ODBC: Msg 0, Level 16, State 1Failed to allocate 360000000 bytes.This process is ran on a Windows Server 2003 SP2 with 4GB RAM and SQL Server 2000 SP4.Does anyone experienced this? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-17 : 16:22:26
|
| Out of disk space? |
 |
|
|
rbrown2012
Starting Member
3 Posts |
Posted - 2012-02-17 : 16:44:34
|
quote:
Originally posted by russell
Out of disk space?
I have plenty of space. The drive is 750GB. the table that I'm trying to recover is only about 3GB in size. I expanded the database that i'm using to 44GB. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-17 : 17:10:22
|
| My bad, looks like an out of memory error on SQL Server. |
|
|
|
rbrown2012
Starting Member
3 Posts |
Posted - 2012-02-17 : 17:36:37
|
quote:
Originally posted by russell
My bad, looks like an out of memory error on SQL Server.
Possibly... The backup files went from about 63GB in size to 100GB. No problem when the files were in that 60-70 GB range. It errors out at about 83GB. I get the same error even when I run it from the command line or Query Analyzer.We'll try to get more memory to throw into the server.Thanks for your response, Russell |
|
|
|
|
|
|
Table Object Recovery Failing