Check out this article. It should help.

http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp

David

Don't forget Visio from Microsoft. This has come a long way!

David

I've only looked at both from a review perspective and the Quest product gets my vote hands down. Interface is far richer. Just my opinion.

David

I think the documentation in BOL is kind of misleading because it says that only the information that has changed since the last full backup is included in a differential...

Are you able to ping this server by name, i.e. ping YourServerName? If this worked well in the past and it is not able to resolve the server name today,...

Do you have the backup set to INIT? If not then you are appending to that backup file and thereby your file size would continue to grow.

Hope this helps.

David

See other post....

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=4907

David

There is a series of articles right here that provide a good start. The link below is the first in a series of 4 that get you started.

Assuming the two files you recovered are fine, that should work.

Note, you are missing comma's after line 2 and 3.

Hope this helps.

David

Oops my bad didn't read far enough down. Looks like you are already doing that. No ideas then because that always works here. Sorry.

David

Did you use the same "(convert(varchar(10), DateCreated, 101))" in the group by clause as well? This should work. Let me know if it doesn't.

David

Andrew,

Here is something that I wrote for a similar problem that you should be able to use as a baseline for fixing your data.

Hope this helps. Format will look...

Have to agree with Andy on this one. Rather loose two days ago backup and try to get a good current one.

Anyway, thanks for finding this out Andy! Good...

Check out this post and see if it helps.

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=2708

David

I will hold until I see the survey to employers comparing the quality of the MCDBA certified employees to those that are not. My guess you will find that in...