Viewing 15 posts - 35,866 through 35,880 (of 39,771 total)
Which version of SQL is this?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 23, 2003 at 10:47 am
I suspect that some of the pointers are potentially out of whack. Can you drop and rebuild this index and then try to run the dbcc. That has worked in...
September 23, 2003 at 10:35 am
That is the easiest way. What doesn't work with this?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 23, 2003 at 10:31 am
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...
September 23, 2003 at 10:26 am
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
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
September 23, 2003 at 10:22 am
no, the name comes from the computer name. Windows won't allow this.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 22, 2003 at 3:14 pm
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...
September 22, 2003 at 3:12 pm
Looks pretty goof Mike. Good luck out there.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 22, 2003 at 3:11 pm
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
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
September 22, 2003 at 3:08 pm
Where is this?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 22, 2003 at 3:07 pm
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...
September 22, 2003 at 3:05 pm
Thanks for the info. Wawnt to write this up as an aritle with a little more detail?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 22, 2003 at 3:04 pm
Shouldn't be any different. If you query syslogins, do you both seem the same rows?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 22, 2003 at 3:02 pm
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
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
September 22, 2003 at 3:01 pm
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...
September 22, 2003 at 2:57 pm
Viewing 15 posts - 35,866 through 35,880 (of 39,771 total)