Hey, welcome to the forum.

This site has some great resources called stairways. Have a look at this one:-

http://www.sqlservercentral.com/stairway/75773/

It's called Stairway to T-SQL DML. That's Transact-SQL the flavour of SQL that...

The master database contains all instance level information so logins, endpoints, linked servers etc.

Best way forward (imho) is to completely review your existing instance, script out or make a note...

If you are just concerned about logins then I wouldn't but are you worried about anything in particular?

GilaMonster (9/3/2014)

---

AppSup_dba (9/2/2014)

---

DB goes into "in recovery" when reindexing runs and log drive becomes full.

DB size - 300GB

Log drive size 100GB.

VLF count 750.

growth rate 1000MB

And take 2-3...

I don't think such a baseline will exist. The time taken to set the cluster and install SQL will entirely depend on your environment.

Hi Gary,

1. You can use SSMS 2014 to manage 2012 & 2008 R2 instances but I have had some problems connecting to 2005 instances.

2. I've got SSMS 2014 on my...

Your database is going into recovery mode probably because of some form of corruption.

Have you run DBCC CHECKDB recently?

The database is rolling back any active transactions by going through the VLFs in the transaction log, the time taken is based on the operations that have to be performed...

The best approach would be to prevent the transaction log of the database becoming full.

Are you running regular transaction log backups?

Are you still getting the same error once the table was removed from replication and the stored procedure executed?

What you could do is use mirroring or log shipping to perform your migration, you could backup & restore your database(s) onto the new server before you intend to migrate....

Have a look at this thread:- http://www.dbtalk.net/microsoft-public-sqlserver-replication/orphaned-entries-sys-objects-after-286901.html

It mentions using the following procedure after the table has been removed from replication:-

EXEC sp_MSunmarkreplinfo 'YOUR TABLE NAME';

GO

First place I'd be looking is the log within Management Studio. If you don't have access then look in the locations that Perry mentioned.

Instead of [Microsoft Query], can you use [From SQL Server] as the data source?

The error suggests that the connection string is defining Datacube_Prog10 as a server name.

The first thing I would do would be to go through the connection string and ensure the...