Viewing 15 posts - 8,761 through 8,775 (of 9,244 total)
Marios Philippopoulos (11/16/2008)
I have heard that Microsoft does not officially support virtualized SQL Server installations.
untrue as far as i am concerned. I had a call open recently with MS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2008 at 6:15 am
Ninja's_RGR'us (11/15/2008)
Wow, amazing stuff, you guys should write an article about this!!!
i have been tempted for some time 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2008 at 2:33 pm
why not just run the scripts through a sql job, no need to use SSIS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2008 at 12:17 pm
although you ran a log backup there could be an active transaction occupying the end of the log file
run
dbcc opentran to check for open transactions
then
dbcc loginfo
a status of 2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2008 at 12:15 pm
Ninja's_RGR'us (11/15/2008)
Any recommended products from your experience?
personally you cant beat VMWare VI3. There are a number of players in this arena now, but remember VMWare have a 10 year +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2008 at 12:04 pm
you need to research and decide on a virtualisation product and storage method first then build from there as the hypervisor and storage mediums form the foundation of the systems
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2008 at 4:33 am
Andrew Peterson (11/5/2008)
The simple approach is to drop and restore the logins with the sid as part of the create login command.
why not just script off the logins from the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2008 at 6:24 am
definitely shutdown SQL server instances.
make sure you have a full backup of the data files before defrag.
Rebuild all your indexes after the defrag
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2008 at 3:28 am
Hi
the first question i need to ask you is
what platform are you using for virtualisation?
We currently use VMWare VI3 comprising of 10 ESX 3.5 hosts
Dont get ESX server confused...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2008 at 3:17 am
stacked IP addresses are another way to have SQL listen on multiple IP's and ports
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 3:43 pm
Steve Jones - Editor (11/12/2008)
You can't, but if it's a daily load, why do you care? The space will get reused tomorrow.
that's a very valid point
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 3:38 pm
rbarryyoung (11/12/2008)
3GB does not sound like anywhere near enough memory for 1000 databases.
unless of course they're all copies of Northwind and Pubs 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 3:13 pm
Dean Jones (11/12/2008)
when enabled and doenst really solve the issue of SQL CLR taking up the whole VAS memory area.
that's not what AWE is for. AWE is so that each...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 3:10 pm
thats more like it although essentially with node 5 inactive you could argue you still have active\passive clustering 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 10:15 am
GilaMonster (11/12/2008)
indexes were been rebuilt sunday evening. Those are logged operations and the log reader has to read through them.
not logged under simple or bulk logged recovery models 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2008 at 9:59 am
Viewing 15 posts - 8,761 through 8,775 (of 9,244 total)