Viewing 15 posts - 41,971 through 41,985 (of 49,571 total)
What compatibility mode is your database in?
January 6, 2009 at 7:27 am
Can you get the full message?
Go to the SQL job, open the job step that's failing. On the 'Advanced' page you can enter a file name for the full output...
January 6, 2009 at 7:26 am
Chris Morris (1/6/2009)
GilaMonster (1/6/2009)
I recommend a 20-sided dice.Six is sufficient...http://en.wikipedia.org/wiki/The_Dice_Man
Maybe for you. 😉 I play D&D. The 20-sided dice is the most important one.
I have 4, 6, 8, 10 and...
January 6, 2009 at 7:15 am
Is the database in full recovery?
Do you have regular transaction logs?
Can you do a final log backup before you restore the backup?
January 6, 2009 at 7:14 am
shiwani2002sg (1/5/2009)
Well i want relation to be generated on the attribute 'A' of both the tables. but in both table A does not include any keys. and its stated...
January 6, 2009 at 7:08 am
Grant Fritchey (1/6/2009)
URGENT!How do you pick indexes... Oh lordy
I recommend a 20-sided dice.
January 6, 2009 at 6:54 am
tony.harris (1/6/2009)
- i.e. having the Database Snapshot delegate to the mirror database for Views, Procedures and Functions?
That's the only way you can do it. Database snapshots are read-only and...
January 6, 2009 at 6:50 am
Can you post the execution plan please. Save as a .sqlplan file, zip that and attach it to your post.
January 6, 2009 at 6:34 am
Grant Fritchey (1/6/2009)
Keep your indexes as small as you can.
But no smaller than necessary. If the index needs to be four columns wide to be useful, making it only...
January 6, 2009 at 6:34 am
free_mascot (1/6/2009)
In addition to the above, I guess Replication do not require index on all the columns. But it require a Cluster Index to get the article replicated.
Transactional replication requires...
January 6, 2009 at 6:31 am
Why do you have 249 or so indexes on a table?
January 6, 2009 at 6:21 am
You can't use a mirror as a publisher, because the mirror database will be in a recovering state and hence unreadable. You can use the principal database as a publisher...
January 6, 2009 at 5:49 am
Jeffrey Williams (1/5/2009)
GilaMonster (1/5/2009)
Meteor hits the server room.
Maybe meteors are a bigger threat for you, but for me I am more worried about the aircraft taking off and landing next...
January 6, 2009 at 5:45 am
Jeff Moden (1/5/2009)
January 6, 2009 at 5:40 am
SQLBOT (1/5/2009)
Will a restore work for getting the backup into a readable active log?
No. I tried that once.
When SQL restores a log backup it replays the transactions recorded against the...
January 5, 2009 at 1:45 pm
Viewing 15 posts - 41,971 through 41,985 (of 49,571 total)