Viewing 15 posts - 4,426 through 4,440 (of 9,244 total)
OS error 2 means the specified file could not be found, was it purged or deleted maybe?
What are your retention periods on the primary and secondary?
To repair the LS scenario...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 4:52 am
If you have role separation in the organisation then the OS and the cluster should be managed by the Windows server team. SQL Server obviously manmaged by the DBAs.
I have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 4:47 am
Follow the original link, it describes exactly what you need to do!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2013 at 10:10 am
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
Viewing 15 posts - 4,426 through 4,440 (of 9,244 total)