sorry didn't know settings on your server. if format is mm/dd/yyyy then yes use

RegisteredDate< '12/13/2008'

so my syntax would have errored for you.

I come from a sensible part of the...

jai_anand2004 (12/13/2008)

---

Hi all,

i am Jayateertha from Mysore India, I have a Problem in sql server 2005 while i was running...

In this case I think the fact the a full backup was explicitly NOT mentioned gave the clue to the expected answer. The issue I believe steve was trying to...

yes. its an...

first of all only shrink the .mdf file if you are sure it won't need to grow to that size again.

If you do shrink it do it out of...

good question steve. I have been thinking of posting a question based on this little 'gotcha' for a while, but hadn't come up with a good wording for it and...

still applies victor. see

http://support.microsoft.com/?kbid=274750

note the section under Windows 2000 Advanced Server or Windows 2000 Datacenter or Windows Server 2003

says

Both SQL Server 2000 Enterprise and SQL Server 2000 Developer Editions...

SQL server 2000 standard edition cannot use memory above 2GB AT ALL. there is no point setting any flags in boot ini

http://msdn.microsoft.com/en-us/library/aa933149(SQL.80).aspx

are you sure there are not two schedules specified within the job?

it would not be the first time a hotfix has reintroduced a problem fixed by an earlier hotfix.

you do want to be at least at SP4 so If I...

50,000 only kept a days history? how many jobs gave you got and how often do they run? Default setting is 1000.

Matt Rose (12/4/2008)

---

DavidB (12/4/2008)

---

Matt,

Sorry for the late reply to this (don't get to check the site very often, a bit busy) but something else to consider is that your...

skyw (12/4/2008)

---

Exactly.

Can you please tell me the queries that I should use to verify that the Transaction Log of the recent changes has been applied to the Secondary Server.

check...

snapshot replication could work for you, but would be more complex to set up and maintain then the good old backup and restore.

replication is really for scale out, where you...

David (12/3/2008)

---

That will only verify whether a backup has ever been taken.

Suppose a backup has been taken on a db in Full recovery mode. Then I change it to...