nimalatissa (5/16/2014)

---

yeah this is now what we are keep doing everyday. the On-call DBA manually takes the backups of all the DBs (about 20). it is working without any issues.

Also...

I loath contained DB's. Sorry I was not much help.

nimalatissa (5/16/2014)

---

Thanks for you reply.

Yeah, we thought about adding the Scripts to a Job and run it. My Manager did not like that idea at all.

Also there is...

Thanks Perry, I didn't see where he had confirmed that it was not AlwaysOn. I asked because I failover through the AG in AlwaysOn. I only use the failover admin...

select * from sys.syslogins

in master database on the server that the login is on.

Depends on the Application \ Vendor. Contact there support team and ask them if it is required.

Perry is totally 110% correct. Make sure before you restart services though that no one is working in the production environment or you will have some explaining to do lucy!...

I see some of your problem. Why do you have your DBCC CHECKDB in with your full nightly backup? These jobs should be separate and DBCC CHECKDB should only be...

Hold the phone guys!

GBeezy,

Fail over is not that hard at all. First let's find out what clustering you are using. When SQL 2012 was setup did you\they setup AlwaysOn?...

That's another way to do it Joseph. If the DB is in Full Recov Mode then you can do log shipping until they are done with the old server. Replication...

I would not recommend switching over while production is going on. This is an at night when people are sleeping change. I would backup the DB, detach it to assure...

the error says it all, your connection string is wrong. Does your SQL server have an instance name or is it default? are you using a default port?

Here is a script that you can use to sync your users back. You will have to add them manually to the new instance under Security. Once the DB is...

Yep your right, I miss read, thanks for the catch!

http://msdn.microsoft.com/en-us/library/ms143241.aspx

and Editions for what they support;

http://msdn.microsoft.com/en-us/library/cc645993.aspx#Replication

no, you can only replicate to Enterprise \ Enterprise.