Viewing 15 posts - 8,911 through 8,925 (of 9,244 total)
WMI, much easier 😎
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")
Set colItems = objWMIService.ExecQuery( _
"SELECT * FROM Win32_LogicalDisk where drivetype=3",,48)
For Each...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:25 pm
in this scenario the best way to analyse the log status is using
dbcc loginfo
look at the status column and they should ideally be 0. The further down you scroll...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:21 pm
GilaMonster (9/8/2008)
Make sure that the account has full control over the directories that have your data and log files in, and also the directories that the backups go.
this shouldnt...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:17 pm
dmc (9/8/2008)
Now on to figuring out the %cpu usage!
give it a go yourself and if you're still stuck post back.
Try searching for "Scripting guy", it'll be a lot of help...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:11 pm
this should get info on all logical drives
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")
Set colItems = objWMIService.ExecQuery( _
"SELECT * FROM Win32_LogicalDisk...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:01 pm
when you create a maintenance plan it creates an associated job with it. Maintenance plans are just a graphical way of creating jobs in sql server!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2008 at 3:09 pm
a2zwd (9/4/2008)
I have my sql server installed in C drive(160GB) and my database files(mdf and ldf) are stored in D drive(40GB). Now my D drive is not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2008 at 2:58 pm
sql authentication modes are either
windows
mixed
in mixed mode windows accounts can still authenticate. Logon as the server administrator and you will gain access to the sql server via the builtin\administrator group....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2008 at 2:56 pm
rc0776 (9/4/2008)
Is it for system with more than 16GB of ram
it shouldnt be used on machines with over 16GB RAM (in fact it could be nearer 12GB RAM)
if your machine...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2008 at 2:52 pm
they will support you up to a point and that point is where they believe the hyper visor is causing the problem. Note their term "commercially reasonable support". If its...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2008 at 6:08 am
i prefer a clean install rather than in place upgrade, main advantage is if anything goes wrong your SQL2000 engine is still available to serve databases.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 4:53 pm
James Horsley (9/2/2008)
(i.e. that whole SAN can go pop - they do you know
a well designed and configured SAN should be capable of losing a fabric and still be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 4:45 pm
what happens when you try
server\instancename?
Have you set the instance to use a static port or dynamic?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 4:35 pm
definitely sounds like an authentication issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 4:30 pm
DavidB (9/3/2008)
The VM solution should take care of making it highly available
that would be depend on what virtualisation platform is employed and how it is licenced\configured!
7 separate VM's for homing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 4:22 pm
Viewing 15 posts - 8,911 through 8,925 (of 9,244 total)