Viewing 15 posts - 43,651 through 43,665 (of 49,552 total)
That looks like it should work. All the logs are there and in sequence, and the first one covers the time of the full backup. Is that giving the error...
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
October 20, 2008 at 3:12 am
You're missing one or more log backups. After restoring the full backup, you need to restore all of the log backups, in order, that were taken since the full backup.
When'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
October 20, 2008 at 2:48 am
What exactly have you tried and what exactly do you mean by 'it's not working'?
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
October 20, 2008 at 2:43 am
Sorry, I don't understand. What's the question?
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
October 20, 2008 at 2:19 am
Inserted and deleted aren't real tables. They're virtual tables that are materialised from the transaction log in SQL 2000 and from the row version store in 2005 and higher. They...
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
October 20, 2008 at 2:17 am
Please put the question in the post, not the header. The header gets trimmed at a certain length.
Fragmentation is just concerned with the order of pages in an index. It...
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
October 20, 2008 at 2:13 am
The optimiser will create the column statistics if it needs to know the distribution of data in that column, and stats don't exist yet. If you create an index, that...
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
October 20, 2008 at 2:10 am
The snapshot file is a sparse file. It may appear to be the same size as the source DB, but it's size on disk is typically a lot lower.
When data...
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
October 20, 2008 at 2:03 am
It's just a limitation on online rebuilds. You cannot do an online rebuild of a clustered index if the table contains any LOB data (text, ntext, image, varchar(max), nvarchar(max), varbinary(max))
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
October 20, 2008 at 2:03 am
You cannot truncate the log of a mirrored database. You should not be truncating your log anyway. It breaks the log chain and means that you will not be able...
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
October 19, 2008 at 12:13 pm
Garadin (10/19/2008)
The code posted was purely for explanation's sake.
Sure, but people are going to see it and possibly take it as an example of how things should...
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
October 19, 2008 at 12:05 pm
It's interesting to see the wealth distributions in different countries. A similar evaluation was done here a couple years back, though I have serious doubts about it's accuracy. Mainly because...
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
October 19, 2008 at 11:33 am
Jeff Moden (10/18/2008)
People need to learn to live within their means... or stop whining when beyond-their-means comes due.
Agreed. The only thing I owe money on is my house,...
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
October 19, 2008 at 11:27 am
You're looking for the inserted and updated tables. In an update, inserted will contain the new values and deleted will contain the old values. Only the rows affected by 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
October 19, 2008 at 11:15 am
Leo (10/19/2008)
Transaction log initial size 4GB [that is okay and I am happy with this size],...
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
October 19, 2008 at 11:12 am
Viewing 15 posts - 43,651 through 43,665 (of 49,552 total)