Viewing 15 posts - 37,216 through 37,230 (of 49,552 total)
Charles Kincaid (8/7/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 1:44 pm
MR (8/7/2009)
I can break it up if need be, but majority of my calls are in the 'else' part - basically, the @componentType is null in most of the cases...
It's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 12:06 pm
The main problem would be with the LSNs. Remove a entry completely and SQL will believe the LSN chain is broken (and it is). Modify the LSNs and suddenly the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 10:46 am
Anyone really know their way around replication?
http://www.sqlservercentral.com/Forums/Topic766992-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 10:31 am
Charles Kincaid (8/7/2009)
Richard M (8/7/2009)
Charles, copy-only backups were introduced SQL Server 2005...... See here
None of my 2005 SSMS installs have the magic check box. Not even recent Express instsalls....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 10:25 am
Charles Kincaid (8/7/2009)
I'm looking forward to the 2008 option of taking "copy only" backups that don't crap on my log chains.
Maybe I'm misunderstanding you, but if you're talking about full...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 10:20 am
Alvin Ramard (8/7/2009)
GilaMonster (8/7/2009)
Example:
A maintenance plan should be set up to truncate, shrink, and backup the transaction...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 10:18 am
GilaMonster (8/7/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 10:07 am
What error?
If it's complaining about the DB not been shut down cleanly then you should restore your latest backup.
If you don't have a backup (and why not), have a look...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 9:59 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic767047-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 9:56 am
Not possible
For someone to even begin to edit the log, the database would have to be detached and they'd have to use a hex editor. I doubt there's anyone outside...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 9:56 am
See this article for posting the exec plan for SQL 2000. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 9:47 am
Warren Peace (8/6/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 9:45 am
Do the tables have primary keys? It's required for transactional replication.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 9:37 am
Does the database contain any objects that can be replicated?
What type of replication have you selected?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 7, 2009 at 9:20 am
Viewing 15 posts - 37,216 through 37,230 (of 49,552 total)