Viewing 15 posts - 7,321 through 7,335 (of 9,241 total)
if you're inserting 10-20 million rows you probably do not want the index in place and the table will load faster, however the index creation will take some time
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2011 at 8:29 am
skosk (1/12/2011)
It is a Windows domain login.
there would need to be a trust relationship between the Forests\Domains
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2011 at 8:26 am
Beth Major-235285 (1/14/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2011 at 7:29 am
you dont really want to install SSRS on a cluster node as SSRS is not cluster aware. Install it to a separate server and use the cluster for the database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2011 at 1:59 am
the MSDTC, like a quorum LUN, only stores logs and configs. I always size it at 1GB for MSDTC and 512MB for a cluster quorum.
It looks very much like you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2011 at 1:19 am
you can use the following to update a passive node also from the command line
SQLServer2008SP2-KB92xxxx-x86-ENU.exe /allinstances /passive=1
or
SQLServer2008SP2-KB92xxxx-x86-ENU.exe /instancename = SQLinst1,SQLinst2 /passive=1
This works for SQL2005 SP2 and above 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2011 at 1:15 am
From the SQL Server Licensing Doc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2011 at 1:05 am
Fish Man (1/13/2011)
I lost my question.
My question is blow.
I need got all objects script for PROD . but my right is not enough. so I want to apply permession...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2011 at 2:40 pm
it's worth noting that the failover policy usually has a grace of 28 days before requiring licenses. As stated, If you intend to permanently run a SQL Server instance the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2011 at 2:31 pm
cjohn5552 (1/15/2011)
I recently installed 2008 R2 (had 2008 before). There are a number of SQL instances at the company that I work for, and most are referred to simply...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2011 at 2:26 pm
The error 3 leads me to believe that at some point the service account has been modified via services.msc
Check the ms kb article for setting manual permissions, google will help...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2011 at 1:44 pm
ensure all nodes are online and on the node currently owning the resources use sql server config manager to change the username and password for the sql server services, then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2011 at 1:31 pm
ensure all nodes are online and use SQL Server configuration manager to change the account and\or password. The cluster service should handle the rest.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 9, 2011 at 3:47 am
Reefchief (12/30/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 9, 2011 at 3:38 am
path and filename of the database or path and filename of the backup file generated by the backup process?
Are your databases backed up natively or using a 3rd party product?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 9, 2011 at 3:31 am
Viewing 15 posts - 7,321 through 7,335 (of 9,241 total)