We are aware and apologies. The ad software and the javascript menu don't integrate that well. You can hover on the right side of the Resources link and you should...

I've seen something like this, but my memory fails me. Let me pass this along to a network buddy and see if he can respond.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server...

no, the name comes from the computer name. Windows won't allow this.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

You still should to run log backups. The log potentially has virtual log files that are not empty and cannot be deleted.

You can use this script to shrink the log

http://www.sqlservercentral.com/scripts/contributions/26.asp

Steve...

Looks pretty goof Mike. Good luck out there.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

not that I'm aware of. Unless the backup was from these files. You can always use clustered indexes to move things to multiple files later.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server...

Where is this?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

That is really the best option for doing this. How big is big?

You could use something like RedGate's Compare utilities and "synch" the schemas, not sure about data. They have...

Thanks for the info. Wawnt to write this up as an aritle with a little more detail?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Shouldn't be any different. If you query syslogins, do you both seem the same rows?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Lumigent is really your only option, but if you only need to "read" the log, then there is a lower priced version I beleive.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server...

Yikes, I'd check the BOL for 6.5. I suspect this is in the terabyte range though. I thought I had a 100GB db sometime ago. I know I had a...

Good idea. Search is one of our week points , but I'll pass along the note to the others. Maybe someone will find a little time.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The...

Thanks for the replys. I'll add them to my list.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

There was an ADO bug that truncated text columns if they were not the last columns in the result set. I don't think that's the case here though.

One other ?,...