on an aside - if ever in doubt or struggling with connection strings visit

http://www.connectionstrings.com

although in this instance failing to include the instance name wouldn't be picked up by that site.

There may be another choice here.

SQL determines when to issue a checkpoint for that database. I've seen several instances of checkpoints being issued way too infrequently on large databases,...

hey no-one said itwas perfect - just a tool to make long winded jobs easier

anyway - many ways to skin a cat - if you don'thave msdb available and you...

perhaps this is a slightly simpler example

create table #temp(tfield varchar(50))

insert into #temp select '00:00:50'

insert into #temp select '00:01:20'

insert into #temp select '01:00:50'

insert into #temp select '00:00:50'

insert into #temp select '00:00:50'

select...

i cheat and get sql to write t backp script for me

here is my script to generate restorecommands

declare @dbname varchar(100)

set @dbname='rssystem'

select 'restore log '+@dbname+' from disk='''+bmf.physical_device_name+''' with norecovery' from msdb.dbo.backupset...

on an aside - why store age as a column - would DOB be better?

I've seen this with linked server connections before. in general linked servers are "bad" (they have a time and place sure)

you avoid using linked servers?

relicate the data or some...

a simple alternative might be

exec sp_monitor (from master database)

this will (without too much accuracy) give you % cpu utilisation between executes of the proc (amongst other things)

the...

hi guys

will be performing the red gate backup and test restore today, but in the mean time

file copy to another disk fails (as per original post) - which is...

already ahead of you - attempting to use redgate sqlbackup.

we suspect this may be a an o/s specific issue in files larger than 50GB.

Cheers

MV

select * from table_name where created_date>=convert(varchar(11), Created_Date, 106) and

created_date<convert(varchar(11), dateadd(d,-1,Created_Date), 106)

completly sargeable

if you look up sargeable criteria you will find that

column name on left hand side

any function(where humanly avoidable) on the right hand side

basic rules of query writing , and...

guys,

apologies for placing this in the sql 2005 section was meant for sql 2000

but have tio flame most of you here....(regret).....

if you read the original post

this is sql 2k...

in that case your largest transaction will when you reindex a table (most likely)

ALTER DATABASE MYDB SET RECOVERY SIMPLE

go

use mydb

go

checkpoint

go

dbcc shrinkfile (logfilename,1)

go

then your log file should never grow beyond a reasonable value (proboably the same size as your largest clustered index) again

problem pretty...