check the source IP in the log entry (should say CLIENT: 127.0.0.1) and see where connection is coming from. Then look there for the reason (schedule jobs, users, applications...

What happens when you backup to the network server, but use an internal volume instead of USB?

What is the largest database size that does work sucessfully?

Yes, that is interesting.. what build/version of SQL are you running? I'll have to watch out for that happening.

interesting, what's this return:

interesting, what's this return:

DECLARE @dataspacetemp TABLE

( FileID int,

FileGrp ...

could be related, may not be. All depends how the application/jobs uses the table. But generally all your tables should have a clustered index that fits how it's...

sp_spaceused includes data and log size, but not log free space..

run "dbcc sqlperf(logspace)"

your log file is probably blown up 🙂

I have script that I use shows job state. So you could do something like this: If job_state = 1, then stop the job using sp_stop_job (

Yea, I see how that could work well for a very large software development team. I'd never let those notebooks out of the office though 🙂

If everyone had a copy of the database with 'sample data', how would you maintain database design across all your developers systems? I have always believed -- SQL engines...

well, I wasn't 100%, but I did a quick google search and found this

http://cfsilence.com/blog/client/index.cfm/2007/1/16/SQL-Server-2005-Express--DTS-Confirmed

I believe the DTSWizard.exe (import export wizard) is in the toolkit (if you are talking about 2005)

http://www.microsoft.com/downloads/details.aspx?FamilyId=3C856B93-369F-4C6F-9357-C35384179543&displaylang=en

Note that you can also change your database, or table collation as well (if you don't want your entire server running that way)

So if you're using SQL_Latin1_General_CP1_CI_AS, try SQL_Latin1_General_CP1_CS_AS

ALTER DATABASE...

You can go through your results and convert them to nvarchar (building an html or text file in an nvarchar(max)) and passing that to sp_send_dbmail.

Or create a vbscript...

Does it run faster if you stripe to multiple files?

Backing up to a compressed volume/folder?

Did the OS Change?

Yep, by putting in the [] in your query, you are looking for table name [dbo].[[dbo].[diskspace_hist]]

not [dbo].[diskspace_hist]