Viewing 15 posts - 1,096 through 1,110 (of 9,244 total)
agent job tokens are detailed at this link
https://msdn.microsoft.com/en-us/library/ms175575.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2016 at 4:44 am
the workaround is not supported by MS, standalone features cannot be added to existing clustered features.
This link https://msdn.microsoft.com/en-us/library/bb630402.aspx details the following
MSDN - Host a Report Server Database in a SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2016 at 4:37 am
sqlserverDBA2016 (11/5/2016)
I wanna move them to 2 new data and log directories
Using backup and restore but would like to keep the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2016 at 7:01 am
VastSQL (11/6/2016)
Perry Whittle (11/4/2016)
is this a virtual machine?Yes
VMware?
Hyper-V?
How many virtual NICS are exposed to the cluster nodes?
Have you run a cluster validation?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2016 at 6:44 am
szejiekoh (11/5/2016)
Good to hear from you! Thanks for replying.!
q1) Can you elaborate further ? Even if msdb has system information embedded within, what is the problem of taking a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2016 at 5:56 am
is this a virtual machine?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2016 at 5:19 am
szejiekoh (10/31/2016)
What would be the best practice to "copy/replicate" these jobs over ?-- doing backup of msdb and frequent restore to the mirrored/replica instance ?
No!
do not do this, MSDB like...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2016 at 4:53 am
sqld-_-ba (11/2/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2016 at 4:50 am
oscarDBA (11/2/2016)
I've been SQL Server DBA for about a year of 5 small databases.
I've read about high availability and I'd like to practice with this feature.
I understand that no one...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2016 at 4:47 am
check the step history carefully, although theyre marked as successful there'll likely be a message indicating logs cannot be applied
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2016 at 4:45 am
service packs may be uninstalled so no real need for worry there.
For the SP install and the inplace upgrade perform these in your test environments first to be sure...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2016 at 4:39 am
Jeff Moden (10/25/2016)
Houston, the OP has left the building! 😀
Probably had a Eureka moment after reading the replies 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2016 at 7:20 am
database mail requires the sql server agent, which express does not have
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2016 at 7:08 am
sql_2005_fan (10/25/2016)
We are planning for a sql server disaster recovery plan with Always on availabilty groups for sql server 2016.
Can we have a sql server failover cluster with the shared...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2016 at 12:37 pm
saravanan.thamidurai (10/24/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2016 at 10:44 am
Viewing 15 posts - 1,096 through 1,110 (of 9,244 total)