Viewing 15 posts - 5,971 through 5,985 (of 9,241 total)
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
deva_etc (10/19/2011)
Also in SQL 2005, you have to perform the patch installation from the active node. In SQL 2008, you can patch from any node (rolling upgrade)
Starting 2005 SP2 there...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2012 at 9:40 am
LutzM (2/14/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2012 at 9:05 am
Muralijv 51742 (2/14/2012)
I will try to restore the logs 4 times a day.Cheers
Murali
In that case log shipping would be perfect
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2012 at 8:59 am
Viewing 15 posts - 5,971 through 5,985 (of 9,241 total)