What other files reside on that volume? If there are other files - are they other database files or are they something else? If something else, you should...

Dan, yes you understand correctly. If you have the space available and expect to continue growing, there is no reason not to extend the database to 300GB.

Yes, with the...

First, for a 200GB file I would not use a percentage for auto growth - I would set it to a fixed size. I would probably set it at...

Another option would be to set the database you want to connect to in the Registered Servers portion of SSMS. Then, every time you want to open a new...

I have to ask, are you performing regular and frequent transaction log backups? If not, then that is the first thing you need to get working - before you...

Well, you just about wrote it 😉

If NA1 is less than booking date then Appt1 is NA1 date

If NA1 is greater than booking date -system shouldnt allow that to happen

If...

jez.lisle (10/2/2009)

Yes the NA dates could...

Okay, can the NA dates be less than the booking date? Are the NA dates NULL or empty strings if they don't have a date?

If the dates are NULL...

I am sorry, but I am not following the logic here. What happens if your NA column is not the same as appt1? What if the booking_date is...

First, is there a particular reason for wanting to stripe your backups? Are you trying to reduce the amount of time it takes to perform the backups?

If so, have...

Are you moving/copying the backup files to other storage (e.g. tape, another server, usb drive, etc...)?

If not, then you really need to think about your restore options and what you...

What you were doing in SQL Server 2000 was incorrect - you should never schedule a truncate of the log (breaks the log chain), or schedule a shrinkfile or shrinkdatabase...

Thanks Matt - now we'll see if this works for the OP.

Okay, I worked through each one and modified the expression - here is the result:

Select ad.uprn As HRN

,sv.completion_date As CompletedDate

...

I reformatted the code a bit, so I could really see what is going on...

Select dbo_address.uprn As HRN

,dbo_service.completion_date As CompletedDate

...