Viewing 15 posts - 4,426 through 4,440 (of 9,241 total)
zi (1/4/2013)
Thanks for replying, is creating database also apply this option because I have created a new database by 50,000 MG but it tooks a very long time.
and sory...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2013 at 10:02 am
jitendra.padhiyar (1/4/2013)
I have clusters on sql server 2008R2, I am learner for clustering on sql. So can you pls guide me regarding cluster on sql server 2008? I can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2013 at 9:05 am
That link is pretty descriptive!!
As the KB says, a rolling upgrade involves upgrading the current mirror, then failing over the databases and upgrading the new mirror (which was previously the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2013 at 8:40 am
zi (1/4/2013)
I have read and applied the instant file initialization but there is no difference?
first : I deleted the database and restored it -- it tooks 5 minites
second: I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2013 at 8:31 am
sql-lover (1/2/2013)
Hi Perry,What am I going to accomplish with that? Given the current file size and settings, results are pretty much accurate, in my opinion.
The HBA queue depth (or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2013 at 7:58 am
Are the domains trusted?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2013 at 7:48 am
You're referring to the older SQL Server 2005 operating modes which were
High Availability (synch)
High Protection (synch)
High Performance (asynch)
The operating modes are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2013 at 11:26 am
sql-lover (12/18/2012)
Any feedback and opinion is highly appreciated ... my main interest is discovered any potential problem, if one, prior going live and before installing the SQL 2012 fail-over instance.
Depending...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2013 at 11:16 am
As already mentioned increase the number of threads for your tests, also increase the queue depth (outstanding IOs) to around 32 or 64 and run for around 5 mins at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2013 at 11:12 am
The fact that it allows a remote connection to the server may raise eyebrows in some organisations. You do have to connect as a member of the sysadmin role so...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2013 at 5:35 am
what is the exact version of your sql server instance?
There was a small bug with the shared tools install on a cluster, you would install the new instance on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2013 at 5:19 am
sreenubabu.s (12/28/2012)
Log Shipping Backup job has failing since 1 week with error message "Disk Space is not enough"
i have checked...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2012 at 1:42 am
If you have a principal server with database file path "D:\MSSQL\MYDBS" and you create the database file "D:\MSSQL\MYDBS\adventureworks_data2.mdf" and the path does not exist on the mirror, this will cause...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 28, 2012 at 7:06 am
SQLCrazyCertified (12/27/2012)
Does anyone know what else can cause the mirroring to be in a suspended state?SueTons.
Creating a new file on the principal when the file paths between the principal and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 28, 2012 at 2:24 am
APA0876 (12/20/2012)
because of the following error:
Rule "Existing clustered or cluster-prepared instance" failed
The instance selected for installation is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 21, 2012 at 12:05 pm
Viewing 15 posts - 4,426 through 4,440 (of 9,241 total)