Viewing 15 posts - 4,921 through 4,935 (of 9,253 total)
ASFSDJG (9/29/2012)
One of my Junior DBA, Created a DB with Log file .mdf extention. can we change it with .ldf extension.
T SQL Used:
RESTORE DATABASE NewDB
FROM DISK =...
September 29, 2012 at 5:03 am
thotvedt (9/26/2012)
No. The SQL Server service runs under LocalSystem. Do you think that could be the problem? I wouldn't think so.
No, just want to accurately recreate your scenario.
Open up the...
September 28, 2012 at 12:56 pm
stillconfused (9/28/2012)
thats kool thanks a lot... and what if we have DTS packages too
How do you intend to store your packages under 2008, filesystem, sql, SSIS?
September 28, 2012 at 9:57 am
stillconfused (9/28/2012)
Can you help me with the process.
If I take backup and restore and later go with revlogin etc stuff can I be getting database objects from 2000 to...
September 28, 2012 at 8:55 am
stillconfused (9/28/2012)
September 28, 2012 at 8:29 am
GilaMonster (9/28/2012)
Rather use sys.stats, not sys.indexes. Column stats (whether manually or automatically created) aren't in sys.indexes.
yes, of course, my bad
marygrace_laurente23 (9/27/2012)
Not...
September 28, 2012 at 8:12 am
Check and post results of the following query
SELECTt.name
, i.name AS index_name
, STATS_DATE(i.object_id, i.index_id) AS statistics_update_date
FROM sys.objects t inner join sys.indexes i
on t.object_id = i.object_id
where t.is_ms_shipped <> 1
order by statistics_update_date...
September 28, 2012 at 6:00 am
you would have to force service on the 3rd node
September 28, 2012 at 4:55 am
SQLSACT (9/28/2012)
Very interesting, do you know if it's possible to remove a nodes vote in a Windows 2012 Cluster?
Haven't had chance to look at the 2012 OS yet, can't see...
September 28, 2012 at 3:55 am
nelsonaloor (9/27/2012)
We have a two node (NODE1 and NODE3)
Do you mean NODE1 and NODE2?
nelsonaloor (9/27/2012)
September 28, 2012 at 3:52 am
karen_jonesdba (9/27/2012)
Could this be used for a site to site DR test
Not really, no.
karen_jonesdba (9/27/2012)
September 28, 2012 at 1:53 am
mohammed moinudheen (9/27/2012)
Very good one Perry.Rated it 5 star 🙂
Hey thanks Mohammed, appreciate the feedback 😉
September 27, 2012 at 11:42 pm
You want to try and achieve an odd number of voting nodes to help maintain quorum, with three nodes Node majority would be default.
However, take this scenario.
You have...
September 27, 2012 at 9:42 am
Viewing 15 posts - 4,921 through 4,935 (of 9,253 total)