Viewing 15 posts - 5,971 through 5,985 (of 9,244 total)
I've voted yes because the existing SQL Server 2008 R2 cluster in my current assignment is using dedicated heartbeat NICs.
However, If i were designing and deploying the Windows\SQL 2008...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2012 at 10:35 am
pwalter83 (2/15/2012)
GilaMonster (2/15/2012)
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1252335-391-1.aspx
This is not a duplicate post....its an altogether different query. Read the post Properly first before writing any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2012 at 10:23 am
Banks1850 (2/18/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2012 at 5:50 am
Banks1850 (2/17/2012)
my understanding was that you cannot apply a SQL 2008 R2 Standard license to the host level of a virtual environment, only to the guest level.
Yes correct, my...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2012 at 3:03 pm
are you applying the licence at the VM level or the Hyper visor host level?
For std edition it only makes sense to apply the licence at the VM level, in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2012 at 1:22 pm
Truncate also resets any column seed values
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2012 at 1:15 pm
fabricio_lima_es (2/17/2012)
I was thinking that with the "timeout" option the failover would obligatory initiate after X seconds. In any situation.Thanks
No it doesn't
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2012 at 11:01 am
sqlfriends (2/16/2012)
I use backup and restore it to a SQL server 2008 server.
Is that the right way to do it?
Or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2012 at 10:09 am
fabricio_lima_es (2/17/2012)
I think I found the answer at this link:I was right. This only work with a windows failure in diferent servers.
Thanks for your time guys.
with instances on the same...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2012 at 10:07 am
don't move the databases, extract all required objects and import them to your new clustered instance.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2012 at 10:04 am
Muralijv 51742 (2/16/2012)
Hi KevinThanks for the update. Do you have suggestions to automate this process.
Thanks in advance.
Cheers
Murali
Not sure what you mean, log shipping is an automated process.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 16, 2012 at 9:21 am
Declaring an Insensitive cursor should also work
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 16, 2012 at 8:26 am
Starting in SQL server 2008 R2 there is a dynamic management function called sys.dm_os_volume_stats which pulls mount point info per database\database file.
I still prefer WMI though 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 16, 2012 at 5:32 am
Personally i prefer to use WMI to get the volume info, it works for mounted and non mounted volumes so it's completely generic
Roy Moore (2/16/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 16, 2012 at 4:57 am
If you really must use a cursor then this would be a little more appropriate
declare cursor_db INSENSITIVE cursor for
select sdb.name from sys.databases sdb
where state = 0 and snapshot_isolation_state = 0...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2012 at 10:01 am
Viewing 15 posts - 5,971 through 5,985 (of 9,244 total)