Viewing 15 posts - 43,666 through 43,680 (of 49,571 total)
Except that you can't repair a snapshot, as it's a read-only partial copy of a DB.
Books Online
October 20, 2008 at 4:39 am
Adi Cohn (10/20/2008)
October 20, 2008 at 4:19 am
oliver.morris (10/20/2008)
Thanks for your reply. Over the weekend I tried to restore the database, I wanted to restore it to say a couple of hours earlier so I clicked the...
October 20, 2008 at 3:42 am
oliver.morris (10/20/2008)
October 20, 2008 at 3:38 am
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...
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...
October 20, 2008 at 2:48 am
What exactly have you tried and what exactly do you mean by 'it's not working'?
October 20, 2008 at 2:43 am
Sorry, I don't understand. What's the question?
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...
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...
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...
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...
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))
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...
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...
October 19, 2008 at 12:05 pm
Viewing 15 posts - 43,666 through 43,680 (of 49,571 total)