It's worth looking at the log sizes first prior to the backup being taken.

If the log has been left unmaintained, then there's a good chance it is accounting for a...

Yeah they both do, and I only suggested it on the basis that the log file was at 50GB (from a standard 4GB), and therefore log shipping and log backups...

Ah apologies, yes you're right, you would have to set RECOVERY to SIMPLE and then run the shrink commands in SQL 2008.

Forgot that this was a discountinued command in 2008...

I may be overcomplicating things, and there may be a much more simple way to do this, but for the first part, you're looking at creating an agent job that...

Have you tried adding default values on the fields within the database?

You sometimes have to set the fields to "Allow NULLs" if the data isn't contained within the set you're...

Personally, I wouldn't shrink the database if you don't HAVE to.

It tends to hit a specific size for a reason, and you'll be hit in performance when autogrowth takes place...

Personally, what I tend to do in this scenario, is set a job to run overnght using SQL Server Agent.

Rather than making alterations to SQL also, if all users are...

No problem, glad you got it sorted 🙂

Are you sure that only one table is affected by the records generated by the app?

There may be other tables which have inserts or updates being run against them and...

Policies are a good thing to manage your SQL Farm with as you get the benefit of being able to control everything from a central location and you can prompt...

Really need further info about whether it's SQL Express for example (where you would often have to manually enable Remote Connections), Named Pipes has been enabled (The error suggests Named...

Excellent, exactly what I was trying to get Iain! 🙂

Many thanks, much appreciated.

Apologies for the bad data sample, I'll be sure to add it in a more quickly usable format...

Many thanks Anthony, it's not quite in the format I was looking to use, but it does help a lot...

I was looking to try and get the format (for example);

COMPANY...

No problem, there are multiple records using the same company, but a range of different companies

Example:

PERSON COMPANY ...

I think the default username and password are;

U: privuser

P: privuser

Try that, otherwise, maybe pubuser/pubuser.

If that doesn't work, you may need to look at ways of resetting the password.