Viewing 15 posts - 1 through 15 (of 469 total)
What kind of changes do you need to replicate? Is you destination server Express or Std/Enterprise?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 7, 2014 at 10:29 am
muthyala_51 (2/26/2014)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 7, 2014 at 10:26 am
Varun R (3/5/2014)
I need to create the replications scripts for the deployment of Transactional replication. I had run the below scripts for configuring the distributor.
sp_adddistributor 'NameofDistributorServer';
sp_adddistributiondb N’NameofDatabaseBeingReplicated’;...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 7, 2014 at 9:07 am
sql_novice_2007 (3/5/2014)
When I run the following query I got the result 0 which means AlwaysOn Avaialability groups is disabled.SELECT SERVERPROPERTY ('IsHadrEnabled');
Does that mean restoring on one Node is good enough?
Thanks.
For...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 7, 2014 at 9:04 am
TravisDBA (3/6/2014)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 7, 2014 at 8:59 am
MysteryJimbo (3/7/2014)
What are you upgrading? SQL Server or the database schema/data?
I understand this will be a 90% schema upgrade and 10% data that uses the new schema
In the case...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 7, 2014 at 8:45 am
Just so you know, SQL serve won't allow two database two have the same physical file name at the exact same location, so it seems like the restore did an...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 5, 2014 at 6:44 am
If you have the SQL 2012 Express with tools installed, see if you can find the system_health session running under Management tab.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 4, 2014 at 10:28 pm
Yes, you can stand up a Standard Edition SQL and migrate your Enterprise database to this instance. However, please make sure to confirm your application or SQL won't require any...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 4, 2014 at 10:08 pm
You can query the distribution database with the view
MSDistribution_Status
HTH.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 20, 2013 at 3:53 pm
Lynn - Thanks for the quick link. I will get with the vendor just so they don't say we don't support it later on, as that would not go well...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 20, 2013 at 3:36 pm
Thanks for the replies folks.
@george - I am not sure if they support DNS alias, but if they do it will be awesome as Mirroring is our go to HA...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 20, 2013 at 3:14 pm
Thanks Lowell. But the result from your query gives .ldf under mdfpath and .ndf under the ldfpath for some databases, maybe because I have multiple ndf files? Also, how do...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
September 28, 2011 at 3:06 pm
And if you want to automate it, you could set up alerts in the event of a success or failure of your backup job.
Thanks...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 17, 2010 at 3:15 pm
shusta (3/17/2010)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 17, 2010 at 3:12 pm
Viewing 15 posts - 1 through 15 (of 469 total)