Viewing 15 posts - 3,241 through 3,255 (of 9,241 total)
Ratheesh.K.Nair (5/26/2014)
I got the below messages.
C:\Program Files\Microsoft SQL Server\MSSQL10_50.R8\MSSQL\Binn>sqlservr.exe -m -
sR8
2014-05-26 16:14:33.41 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:33.41 Server ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2014 at 8:25 am
Minto Minto(quendans) (5/26/2014)
recently we configured sql 2012 cluster. After installing ,i tried to check the failover from node to node.Form active node i stopped services but it is not getting...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2014 at 7:25 am
Carlton Leach (5/21/2014)
does it allow you to:- create a 2 node cluster, 2 Standalone instance, with no shared disk?
Yes that's pretty much a basic configuration with an AlwaysOn...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2014 at 11:00 am
curious_sqldba (5/20/2014)
thank you for the wonderful post.
You're welcome.
curious_sqldba (5/20/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 3:46 pm
Granting SQLAgentReaderRole will automatically grant the base SQLAgentUserRole too.
A user who has the base User role can only see jobs that they actually own, they'll see nothing else.
A user who...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 9:05 am
So, you have a new server for your planned cluster to add to the current machine with the stand alone instance.
Do you have a maintenance window or agreed downtime period...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 7:56 am
TheSQLGuru (5/20/2014)
Perry Whittle (5/20/2014)
There'll be some history somewhere. Have you thought of logging the job step output to a text file?
Taking another opportunity to steer the user (and every SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 7:46 am
It sounds to me like you're planning to switch the fibre volume with the standalone instances system databases and connect it to a new server as a clustered instance, is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 7:26 am
as i suspected, you must grant Share\NTFS permissions to the SQL Server service and not yourself 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 7:24 am
arooj300 (5/20/2014)
yes folder are shared. and I am using with Wizard.
So, who did you grant permissions too??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 3:13 am
simple, don't backup to a network drive. You'd be better off taking backups locally and then copy them to the network. Backing up directly to a network drive requires a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 3:12 am
There'll be some history somewhere. Have you thought of logging the job step output to a text file?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 1:24 am
arooj300 (5/19/2014)
Yes I am trying to restore in Secondary Database.
Manually or via the wizard?
arooj300 (5/19/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 1:18 am
arooj300 (5/19/2014)
I am new in log shipping. When I am generating log shipping from one server to another Server. I am getting below error:
cannot open backup device "\\primary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2014 at 4:02 am
Perry Whittle (5/16/2014)
can you post details of the maintenance plan and job history
No history at all ??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 17, 2014 at 11:27 am
Viewing 15 posts - 3,241 through 3,255 (of 9,241 total)