Viewing 15 posts - 1 through 15 (of 112 total)
craigvincent (11/14/2012)
I've been trying to do a similar thing to you - logging performance data to SQL for two separate machines, which were not part of a domain and...
November 14, 2012 at 1:05 pm
I do not have experience of clustering but following posts of HA to gain some knowledge. So please let other expert validate my answer.
Conceptually this looks possible.
Only thing needs...
August 29, 2012 at 12:46 pm
I am just trying to understand this post, are you looking for something like this?
Node1______________________Node2_____________________________
Instance1(active)____________Instance1(failover)____---This is for Application A
Instance2(failover)___________Instance2(Active)_____---This is for Application B & C
August 29, 2012 at 9:58 am
backup will expire options was 0 days
This option is equivalent to infinite days (never expire)
Run following sql to check how many backups your media file has?
RESTORE HEADERONLY FROM DISK =...
August 28, 2012 at 1:05 pm
I would run cmd.exe using system account and give a try running bat file to find interactive issue.
How to run cmd.exe as system account
I had similar issue when I was...
August 24, 2012 at 2:02 pm
With no detailed information this is my guess...
problem is not PK, but clustered index. By default PK becomes clustered index. By creating seperate clustered index (identity column) should resolve...
August 2, 2012 at 7:27 am
Lavanyasri (7/26/2012)
I tried the below scenario but its not creating indexes.generate script: right click DB in SSMS -> Tasks-> Generate Scripts...
Did you make sure "Script Indexes" = true, in...
July 26, 2012 at 9:35 am
Lavanyasri (7/26/2012)
July 26, 2012 at 9:08 am
Daxesh will the DB in a readable poisition if it is in stand by?
Yes
July 26, 2012 at 8:29 am
dakshinamurthy-655138 (7/26/2012)
It worked for us Successfully.
Again i need one more clarification, assuming that i used the command STOPAT and then if i have iterate the timings...
July 26, 2012 at 8:07 am
I had similar issue few months ago (check if this is applicable to you or not), we were taking backups over the network from many database servers (6-7 at a...
July 25, 2012 at 1:39 pm
shiv-356842 (7/25/2012)
Hi Team,In Principal server user tables are not appearing, how can re-store the all the table please suggest me.
If objects have been dropped, there are chances you have...
July 25, 2012 at 8:53 am
SQLKnowItAll (7/24/2012)
One to start: http://www.sqlskills.com/blogs/joe/post/What-sysdm_db_index_usage_stats-may-not-tell-you.aspx
Excellent article! I was really not aware of this. Thanks a lot for sharing
July 24, 2012 at 1:57 pm
What if this DMV was not updated based on the operation that was run? Best bet for anything like this is a server-side trace.
Server-side trace can be the best...
July 24, 2012 at 1:50 pm
I am not sure I understood it clear. But you log result of following query at nPM and nAM and compare the resultsets should give you what you want.
select DB_NAME(database_id)...
July 24, 2012 at 1:03 pm
Viewing 15 posts - 1 through 15 (of 112 total)