You can try one of these and reset up replication afterwards.

sp_removedbreplication

sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'publish', @value = N'false'

No. Different database, different files. You cannot "move" the pages from one to...

Ok. This poses another question. If the updates drops/creates does it remove the article from the publication? You cannot drop a published table without removing it from replication

Altering objects...

In theory you should never have to resetup the whole publication and reinitialise. Some more questions.

Do you have any visibility of what articles are changing as part of these...

Whats your current experience?

Take another log backup outside of the schedule to a different location

Daylight savings changes can occasionally have an impact

This is why I'd be tempted to implement a faux geo cluster. It's near zero loss and removes the administrative overhead. I currently have a project to implement several of...

I've posted this before, but you can do geo-clustering without shared storage provided you purchase 3rd party disk mirroring software.

http://clusteringformeremortals.com/2009/10/07/step-by-step-configuring-a-2-node-multi-site-cluster-on-windows-server-2008-r2-%E2%80%93-part-3/%5B/url%5D

As mentioned, there are multiple ways of accessing remote databases but to automatically gather the data using SQL Server you will need a SQL Agent job to run something.

You then...

Tell him I've got servers using 240GB. SQL Server will use whatever it needs

As a minimum I would have 5 drives if your budget allows.

-System drive 100GB

-Page file drive (20GB?)

-SQL Data drive

-SQL Log drive

-Tempdb drive

You can get away with three by merging the...

Like this?

ALTER DATABASE [TestDB] MODIFY FILEGROUP [ReadOnly] READONLY

GO

ALTER DATABASE [TestDB] MODIFY FILEGROUP [ReadOnly] READWRITE

GO

ALTER DATABASE [TestDB] MODIFY FILEGROUP [ReadOnly] READONLY

GO

From my point of view, SP level transactions are preferable to .Net ones. I would only use a .Net transaction in my code if I needed to execute a...

GilaMonster (1/16/2012)

---

Revenant (1/15/2012)

---

the fact is that there is 2012 waiting for the official release; IMO all adequate tests today ought to be for that one - the newest version -,...

To be brutally honest, if you havent done the research into certifications and discoverd MCDBA certs were retired yourself I would question whether I'd hire you.

Admittedly Microsoft still have an...