What kind of changes do you need to replicate? Is you destination server Express or Std/Enterprise?

muthyala_51 (2/26/2014)

---

We are planning to move the distribution database from one domain to another by restoring system backups. What kind of precautions we need to take in order to finish...

Varun R (3/5/2014)

---

Situation:

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’;...

For...

TravisDBA (3/6/2014)

---

As far as work ethic goes, what is the most important work ethic in a DBA? For me, it is self-sufficiency. Nothing is more frustrating than a DBA that...

I understand this will be a 90% schema upgrade and 10% data that uses the new schema

In the case...

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...

If you have the SQL 2012 Express with tools installed, see if you can find the system_health session running under Management tab.

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...

You can query the distribution database with the view

MSDistribution_Status

HTH.

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...

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...

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...

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...

shusta (3/17/2010)

---

I have a database (SQL 2005 Std) that has the Recovery Model set to full and all I do is a nightly Full backup (nothing else) and a weekly...