Viewing 15 posts - 3,256 through 3,270 (of 9,244 total)
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
Are the collations different
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2014 at 11:47 am
yes he does join back to sysprocesses
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2014 at 9:06 am
open SSMS, right click db to export from and select export data.
on choose a destination dialog drop down destination and select flat file
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2014 at 9:05 am
either use windows update or click this link.
Click the download button and on the pop up window scroll down to find SQLServer2012SP1-KB2674319-x64-ENU.exe
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2014 at 9:01 am
lkennedy76 (5/16/2014)
Thanks Perry, I didn't see where he had confirmed that it was not AlwaysOn.
OP confirmed it here
GBeezy (5/15/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2014 at 8:54 am
lsalih (5/16/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2014 at 8:14 am
nimalatissa (5/15/2014)
Here is the Maintenance plan and the Job running
can you post details of the maintenance plan and job history
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2014 at 6:48 am
GBeezy (5/16/2014)
Evicting and Draining within Fail-over Cluster Manager definitely didn't sound right
That one will have you typing your resume quicker than you can select "Node" -> "Evict Node" 😉
You should...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2014 at 6:34 am
APA0876 (5/15/2014)
Hi,How to change the sql service passwords on a SQL 2012 cluster - thanks
Thanks
From the instances active node open SQL Server configuration manager.
Change the service passwords and apply, you'll...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2014 at 5:02 am
GBeezy (5/15/2014)
I am not seeing this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2014 at 4:58 am
george sibbald (5/15/2014)
p.s. might be a line comment missing from the restore TSQL shown?
This has now been fixed
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 15, 2014 at 10:17 am
Divine Flame (5/15/2014)
Nice article Perry. Thanks for sharing.
Thank you, you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 15, 2014 at 10:14 am
Viewing 15 posts - 3,256 through 3,270 (of 9,244 total)