You should set your backups to be done as jobs in SQL Server.

If you MUST have the app do it, the app should have a way to schedule the backups...

If you don't care if the database is available to users, detach it. Copy the .mdf and .ldf files. Then reAttach it.

But Grambowk's suggestion is the best. If possible, use...

You can not do transaction log backups if:

The database is Master

The database is MSDB

The database is in SIMPLE recovery mode.

-SQLBill

I use QA a lot to edit stored procedures and that has never happened to me.

What edition of SQL Server are you using? (6.5, 7, 2000, 2005)

What version (service pack/hotfix...

Okay...I found the answer.

Refer to the BOL, use the index tab and enter SQL Server, capacities. Scroll down to find the section for Maximum Amount of Physical Memory.

Developer Edition has...

Do you have a licensed version of Developer or did you install it as a Evaluation version? I believe that Evaluation versions have a 2GB limit.

-SQLBill

Here's the simplest way to get started and learn...

In Enterprise Manager, expand until you see Management. Expand that. Click on Jobs.

Right click on Jobs and select New Job. On the...

While it was correct, the answer wasn't complete. Per BOL, VARCHAR defaults to 1 when it's used in a data definition or variable declaration statement. BUT it defaults to 30...

I use the 'native' SQL Server commands to backup the database and log to disk, then I use Backup Exec to copy the backup files to tape. All of...

SQL Server doesn't know that you don't want that extra space. It doesn't really know that it is unused space. It just knows that the backup uses 80 GB of...

XP is not a SERVER version of Windows.

SQL Server 2000 Standard or Enterprise edition requires a Server version of Windows.

If you try to install SS2K Standard or Enterprise on a...

As everything with management, you show them there is a problem and what the best solution is and they say we'll get around to that. We are looking at...

It depends on why you are changing the procedure. I have changed some system procedures, specifically sp_spaceused. Spaceused returns more data than I normally need, so I changed it. However,...

(quote)It seems obvious that it would be faster in single-user mode, but I don't know how you would estimate the time difference with no test system.(end quote)

This is why I'm...

That is basically what the 3rd party purge does. It breaks it down to 100 rows at a time. My question isn't about how to do the delete....I have...