Viewing 15 posts - 391 through 405 (of 469 total)
SAN goes down???...:w00t:. I am glad we have a one year tape backup retention policy..:cool:
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 16, 2008 at 10:07 am
I hope this does not break the log chain.This needs to be done on Prod Db, that's the reason I am leery about this. In case I switch the recovery...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 16, 2008 at 10:01 am
Did u have updates in the past 3 days??
How much of data do u expect you would need to recover??
What about the backups, when was it run the last time,...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 15, 2008 at 12:29 pm
Interesting to know all kinds of setup with respect to assigning tasks for DBA's in batches. Well I am the only DBA for all environments but one positive thing is...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 15, 2008 at 11:35 am
Is it a disk backup or a tape that you are restoring from?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 15, 2008 at 10:13 am
How to view page spilts in a table? Also what is the desired value for % EXTENT FRAGMENTATION?
Thanks!!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 15, 2008 at 8:43 am
How do I set a variable fill factor, because the way I see it there are a bunch of tables that are static and then there more than a couple...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 14, 2008 at 11:43 am
All the mdf and ldf files are stored on separate RAID 10 drives with 50 spindles each. The backups again are on a separate RAID 5 array. I am not...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 14, 2008 at 11:41 am
I used this script on some smaller databases to reindex in the past
select getdate() as TotalStart
exec sp_MSForEachTable '
print ''?''
select getdate() as starttime
DBCC DBREINDEX(''?'')
select getdate() as endtime
print ''-----------------------------------------------------------------''
'
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 14, 2008 at 11:34 am
Hi bkDBA: The issue is slowness of the system. We are got rid of 5-6 years of data and to ascertain if we actually have a performance boost we are...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 14, 2008 at 11:32 am
Batching the index job in two sets : Does that mean I issue multiple DBCC commands?
Gail :The test server is 4X16 on 2000 SP4, prod on 8X16 2000 SP4. We...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 14, 2008 at 11:22 am
It took 4-5 hours to rebuild one Index(clustered)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 14, 2008 at 11:13 am
MANU the article was very helpful. I don't think there is any hotfix to take care of it. But then can I set up a job to notify me upon...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 10, 2008 at 7:44 pm
Backup restore is the best bet.But make sure you have everything sorted out before you start to mitigate the downtime....
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 10, 2008 at 6:42 pm
We use spotlight, never had any issues with it. I suggest you request a demo for spotlight at http://www.quest.com.The licensing and all issues can be asked for with the support...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 10, 2008 at 5:15 pm
Viewing 15 posts - 391 through 405 (of 469 total)