I looked at this a little while ago, i don't think you can and when its filled the disk sql stops working.

Someone may have a solution though.

can you backup the database manually...i.e. not through maintenace plan?

Also what's the compability mode of the database?

What error are you getting?

Have you tried using the master database.

Basically the restore is failing because you have a connection to the db, if you run the script under the contect ofmast this remove...

The package, written by another person, was connecting to excel using JET. The 64 bit didn't like it. i cahnged the connection to use OLEDB and it worked fine. It...

BIDS will only run on 32 bit....SSIS itself will run fine on 64 bit. so design your packages on you desktop and delpoy them to the 64 bit server.

I went...

check out this link:

http://blogs.msdn.com/slavao/archive/2005/08/31/458545.aspx

It may or may not be neccessary...

Are you getting "SQL Server memory page out..." error in the error log?

aside from that but on the same topic, redgate has a new tool that will generate test data for you, i have only used it once but it seems quite...

I Agree with all that has been said before.

If you don't have access to the existing master db, a backup of it or don't have the logins scripted out...

There's a resource govenor new in SQL Server 2008. Don't think there is anything avaialble in 2005

I think Microstf recommened enabled the 'lock pages in memory' option for Standard edition on the 64 bit platform. There are some knowledge base articles on this

I don't think you can load balance SQL Server out of the box.

Windows and SQL Server clustering offer high availability but not load balancing. Your SQL instance will olny run...

Hi debs i was going to suggest that a log missing....:)

Glad that you have resolved your issue.

If you are restoring logs to the standby "log-shipped" database then you do not want to use the WITH RECOVERY option. Using this option will mean you can apply no...

Thats a different question 🙂 don't know enough about replication between sql 2005 and its differenet variants and sql 2000 to say you won't get any issues, what problems are...