Viewing 15 posts - 1,276 through 1,290 (of 9,244 total)
for multi subnet clustering see these links
https://msdn.microsoft.com/en-us/library/ff878716.aspx
https://msdn.microsoft.com/en-us/library/hh213080.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2016 at 4:38 am
alter the log shipping configuration to disconnect users during the database restores. Its not an error you're seeing, you've told LS you don't want to disconnect users. When the connections...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2016 at 11:37 am
there are no PoSh cmdlets to control logshipping, logshipping is handled by SqlLogShip.exe.
What you could do is use PoSh to execute the TSQL scripts used to enable LS, but then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2016 at 11:35 am
Mad-Dog (4/13/2016)
I've SQL Server 2012 STD and SQL Server 2014 STD and i need to implement some kind of DR or HA to it so i can reduce the load...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2016 at 11:26 am
I've been required to backup dev databases before now, it depends on requirements
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2016 at 10:59 am
AlexSQLForums (4/14/2016)
I have a 2 TB Production db in AlwaysOn synchronous auto failover mode.
I have a 600GB(230 million rows) table which I would like to move to it's own...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2016 at 10:58 am
8adger (4/13/2016)
Thanks very much for your reply. What you suggest is essentially what i have done.
I have configured a number of availability groups on Server A and they are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2016 at 10:54 am
8adger (4/12/2016)
If I have Server A and Server B and want to use them both like active active sql clusters but with Availability Groups so not true SQL clusters do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2016 at 10:52 am
tcronin 95651 (4/14/2016)
Built active passive 2014 Ent Edition Cluster which seems to be fine.
Added a stand...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2016 at 10:45 am
Nested roles can be a pain for this exact reason, at least you've found the issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2016 at 11:47 am
there is a retention period defined for the location where the primary writes backups and also defined for where the secondary copies the files too.
On the Primary
exec sp_help_log_shipping_primary_database @database =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2016 at 8:52 am
JimiHaze (4/12/2016)
Yes, I changed all of your examples into what I needed.
does the login own the database by any chance
select suser_sname(owner_sid), name
from sys.databases
where database_id = db_id('yourdb')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2016 at 8:35 am
gaurav_ghiya (4/12/2016)
1. Do I have to backup the Service Master Key? If yes, why?
Yes, It's unique to the instance and used to encrypt objects within the instance
gaurav_ghiya (4/12/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2016 at 8:30 am
JimiHaze (4/12/2016)
LoginSID : 0x010500000000000515...DBUserSID: returned nothing
you set [yourdb] and the user name string before executing?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2016 at 8:23 am
yes, it's no use now.
For future reference, if you have a broken LS plan and the query produces results with identical LSN bases this means that no full backup on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2016 at 8:22 am
Viewing 15 posts - 1,276 through 1,290 (of 9,244 total)