Do you have lots of large data types or images on this database?

What version of Litespeed?

How many files are you trying to restore?

Can you post the script?

EDIT: Almost forgot to ask, does the restoring box have Litespeed installed?

Jack Corbett (3/23/2011)

---

I'm not going to make the duck tour, but I am planning on getting into Boston somehow for the dinner. I hate driving in any city and...

You didn't give it a target_size?

Run SP_WHO2 to see if anything is blocking the process. Double-check the hard drive to make sure it isn't full. Double-check the tempdb (and...

Also, why are they not in synch? Did something break? Was something stopped?

Are you restoring natively, using the Litespeed console, or using a restore job / script created by Litespeed?

Are you restoring to the same box that the backup was made on...

It depends.

I know that answer blows, but it really does depend.

1) Database shrinking or File shrinking?

2) Through the GUI or a DBCC command?

3) If you used the DBCC command, please...

It wasn't. Just started it, retried starting SQL Server Agent Service and got the same error message.

Again, what Gail said.

But in my original analogy, the parts of the plate covered with cookies were the active VLFs and the empty parts of the plate were the inactive...

I've just opened up a new connect issue with the details of the SQLAgent.Out.

EDIT: OS is Vista Business 32 bit.

Here's what I've posted:

"2011-03-18 13:34:41 - ! [298] SQLServer Error: 65535,...

Gah. This is seriously annoying. Neither Repair nor an uninstall / reinstall fixed the issue.

Any more thoughts?

Kokila, thanks for the advice, but as stated above, the service account is running under full Sysadmin permissions (which would be a complete no-no if I were running this on...

I've never even heard of anyone executing a query plan before. Just a query.

Are you trying to execute a query with a specific query execution plan instead of letting...

Add your data type sizes (per row) and multiple by the number of rows in each table. This will get you the uncompressed size.

Don't forget to add the overhead...

Self-study has always worked best for me as I tend to forget class-taught items a week after the class unless I actually practice them.

Getting books and working through the exercises...