ashanair70 (12/4/2011)

---

We are setting up a new server instance with about 50 databases but only 4 of these databases have any data in it.

If there is a need to...

Michael Valentine Jones (12/3/2011)

---

That code is sensitive to the setting of DATEFORMAT....

You can reduce your backup time by using one of the third-party tools that compresses backups.

Redgate's SQL Backup

Quest's Litespeed

Idera's SQL Safe

All of the above are good options, and each one...

junk.jjk (12/2/2011)

---

Alright, thanks for looking at my code. I'll try letting the tempDb grow for a few days and see if it 'levels-out' at a new, larger size.

The other...

Select dateadd(month, datediff(month, -1, cast(@year as char(4)) + '-' + cast(@month as varchar(2)) + '-01'), -1)

Can you change the owner of the database to 'sa' - and then add this user with db_owner rights?

Glad to have helped.

sqlfriends (11/28/2011)

---

Thanks, but full backup also takes much space. Can I change it to bulk-logged then do the delete, then change back to full recovery mode, this way I don't...

Steve Jones - SSC Editor (11/28/2011)

---

I think LEN is a holdover from the other languages where that's a common function. Not sure when DATALENGTH was introduced (it's in 2000), but...

sqlfriends (11/28/2011)

---

I realize I should have said I don't have enough space on the backup drive, for Log drive it is fine now.

So how can I reduce the log backup...

quillis131 (11/28/2011)

---

kramaswamy (11/28/2011)

---

Is it possible that you have spaces which you aren't counting? If SQL Server tells you the length is greater than 20, and when you count the characters...

There will always be at least one VLF that is inuse - it is probably the one you are looking at.

For question 2 - if you already have the plan open in the editor to modify, then trying to modify again won't do anything.

For question 1, there is a small...

Jeff Moden (11/27/2011)

---

I believe Tom has this nailed. The Green Arrowhead used to be the "run" command prior to SQL Server 2000. In 2005 and up, it's now...

Also, verify whether or not there are primary keys defined on the tables. That could also be causing the tables to be read only from ODBC.