Viewing 15 posts - 30,736 through 30,750 (of 49,552 total)
If the principal becomes corrupt it is highly unlikely that the mirror will as well. Corruption is an IO subsystem problem and, since mirroring just copies log records, such corruption...
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
September 13, 2010 at 8:51 am
Full backups do not and never have truncated the transaction log. Hence full backups won't affect any chain of log backups including the one for log shipping.
Don't understand the corruption/backup...
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
September 13, 2010 at 8:50 am
Use the system tables to generate DELETE FROM statements for all tables. Run repeatedly until there's nothing more to delete (assuming you have foreign keys. If not, one run will...
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
September 13, 2010 at 8:44 am
If you restored the database WITH RECOVERY (bringing it online) then to restore more log files you need to restore from scratch the full backup and all logs.
Once the database...
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
September 13, 2010 at 8:22 am
Raghavender (9/13/2010)
We are doing Index Defrag.
Defrag only works on the leaf level of the index (level 0), so what you are seeing is expected and by design. If you want...
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
September 13, 2010 at 8:19 am
The columns that are defined as BLOB data type, what are they supposed to be storing?
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
September 13, 2010 at 7:43 am
The script won't work fine, because there are other syntax errors in it. Like the BLOB data type.
This looks like an MS-Access script. Is it? If so, you can't just...
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
September 13, 2010 at 7:18 am
And Books online? Should be installed locally if you have any portion of SQL installed.
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
September 13, 2010 at 7:11 am
Raghavender (9/13/2010)
So which one we need to take into consideration and if we...
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
September 13, 2010 at 6:55 am
Did you read the articles that search returns? Have you read up on client redirection in books online? (hint, a witness is not involved in transparent client redirection)
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
September 13, 2010 at 6:54 am
Raghavender (9/7/2010)
as you can see same index is repeating 2 times on the same table with different fragmentation values.
Perfectly normal. When you query index_physical_stats in detailed mode, you get one...
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
September 13, 2010 at 4:37 am
forsqlserver (9/13/2010)
I have also the single database but I want automatic connectivity of application to database if primary server fails..Guide me for this...
http://www.google.com/search?q=%22transparent+client+redirect%22+mirroring
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
September 13, 2010 at 3:00 am
You may want to call MS customer support on this. Deadlock on communication buffer is an odd one.
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
September 13, 2010 at 2:58 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic984554-1550-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
September 13, 2010 at 2:54 am
You can't. To restore you need a full database backup. A transaction log backup does no contain the entire DB, it contains only the record of changes that occurred in...
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
September 13, 2010 at 2:53 am
Viewing 15 posts - 30,736 through 30,750 (of 49,552 total)