No, the backup log command does not work with simple mode.

You would use dbcc shrinkfile.

This is like saying you forgot your Windows sign on and what can we do? There's nothing we can do. You need an admin to help as noted above.

You should set your maintenance plans to log, they can do this in text files and don't necessarily need to send to the SQL Server error logs.

Go search for another file, who knows what name, but a .bak file with the same timestamp as this one.

If you are loading often, you're creating a hot spot on the disks. Logs could be an issue here.

I'd get the logs onto separate disks, a small R1 array could...

Is there an error logging switch? Some loaders can throw the bad records elsewhere.

Otherwise you need to look at the error and then try to figure out which row(s) it...

Change the script, figure out which process is doing what you need and don't kill that one.

The bcp/truncate works well if you can. I typically delete large sets of data in batches, 10k rows or so at a time. Seems to work faster.

You always want free...

What is "gets done"? Do you mean updated?

This is what you want. We don't want to have to update all instances with patches. You apply the patch twice.

SQL Server doesn't automatically delete the files, someone had to move them or delete them. I'd investigate moves. Search for them on the drives, a shaky mouse hand could have...

The groups will cause the user to be validated against AD with the trusted connection. This is what you're after, though it might seem a bit funny. When the user...

The design is fine for storing the data, but having those LIKE queries will slow you down and guarantee that the server works hard on every query.

You want to query...

Perhaps a silly question, but have you rebooted? i've seen that clear up some bad query plans.

Do you have any reference execution plans to examine the slow queries and see...

We tried this at one point and almost no one commented. Once they hit another site, they tend to comment there.

I think comments are best left on that site, with...

Good point, and it might be something we ask Instant Forums (the maker of the software) to include it. I can see value in the OP.

Popping a new window doesn't...