Viewing 15 posts - 6,046 through 6,060 (of 9,244 total)
check the cluster error events within failover cluster manager for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2012 at 11:53 am
MarkThornton (1/24/2012)
I TRUNCATEd the offending table
There was never any doubt this would work as the truncate will de allocate all the pages, no ghost records to clean up!
MarkThornton (1/24/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2012 at 10:40 am
You shouldn't treat the VM any different to s physical machine. How do you back up these?
Options such as VMWare vmotion make a virtual machine highly available and all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2012 at 1:16 pm
The SQL server 2008 installer has an option to maintain SQL server editions. Run the installer and check the maintenance section, from memory it's in there.
Just out of interest, why????
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2012 at 1:08 pm
Have you checked the subversion help material? This will give you a basic idea
http://svnbook.red-bean.com/en/1.7/svn-book.html
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2012 at 11:05 am
cor_perlee (1/23/2012)
, @database_nameVARCHAR(32)
database name would normally be a data type of SYSNAME or NVARCHAR(128). varchar(32) could result in the database name being truncated
What is the schema definition of this table
Unit4_Beheer.dbo.DATABASES_TO_RESTORE
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2012 at 8:34 am
execute the following query against the principal and the mirror instances
select sid from sys.sql_logins where name = 'yourlogin'
The output will be different. You can either use sp_helprvlogin as already suggested,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2012 at 7:03 am
chandan_jha18 (1/20/2012)
Can I go beyond 8 logical CPUs(visible to SQL Engine) on a VM. I am not able to understand the online material to my satisfaction.Kindly help.
Thanks
Chandan
The number of virtual...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2012 at 6:16 pm
shijimon.jacob (1/20/2012)
Thanks for your clarification on this.
One of the articles on MSDN states the below.
http://msdn.microsoft.com/en-us/library/ee308825(v=bts.10).aspx
"SQL Server 2008 and SQL Server 2005 Standard Edition supports 2-node failover clusters. If you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2012 at 5:44 pm
kellithompson (1/20/2012)
Yes it is. It's off-site at another location, but it's the same domain.
That makes things a whole lot easier. Just set mirroring up as defined in BOL. I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2012 at 12:17 pm
Pieter Vanhove (1/19/2012)
Hi,Did you manage to fix your problem because I have the same issue on my cluster...
Regards
Start a new thread giving details of your issue where people will be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2012 at 1:28 am
Generally when passing multiple parameters to a dynamic SQL string you would declare and pass the parameters as the link specifies, Michelle's script doesn't but then it's only passing a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2012 at 5:12 pm
Is the stand alone server part of the same domain as the cluster or is it in a workgroup.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2012 at 4:17 pm
shijimon.jacob (1/18/2012)
Hi,So if I go for a 2 node windows cluster, I can have more than 2 clustered instances on them using Sql Server 2008 Standard Edition?
you're now confusing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2012 at 10:44 am
just to re iterate, you only need a backup of the certificate and its private key and a backup of the database itself
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2012 at 4:17 pm
Viewing 15 posts - 6,046 through 6,060 (of 9,244 total)