USE master

ALTER DATABASE [database] SET PARTNER FAILOVER;

GO

kirankritapure (3/10/2016)

---

I am restoring few databases from 2008 backups to 2014. I used litespeed and SQL server native restores. But every time the physical file names are being generated as...

Is this your issue?

You experience blocking, deadlock conditions, or other SQL Server issues when you try to connect to the BizTalkMsgBoxDb database in BizTalk Server

Here you go: http://jonmorisissqlblog.blogspot.com/2016/02/orphaned-users.html

Move User Databases

SET OFFLINE with rollback immediate

Physically copy files

ALTER DATABASE [DB] MODIFY FILE ( NAME = X, FILENAME = Y)

SET ONLINE

Verify

Physically delete original file

Determine the Version of the JDBC Driver

On a side note, only AES_256 is unbreakable, if it even still is unbreakable...

Check this: Using Missing Index Information to Write CREATE INDEX Statements

It's saying to create an index on the "equality_column", however you have to test and also take into consideration any indexes that already exist (I.E. index consolidation).

Check this out: Choose an Encryption Algorithm

are you calling you script (from sqlcmd) using -i?

I'm wondering if your .sql file that your calling is saving the unicode correctly...

(try saving the sql file with another text editor.)

I don't see -sa in your sqlcmd call. Is %userName% "-sa" or is it "sa"

FULL/DIFF/LOG is a good strategy, but you might want to overnight the FULL. Also, if you can, avoid anything that's going to cause a lot of changes, like index...

How do I increase the maximum allowed attachment size for email sent using msdb.dbo.sp_send_dbmail in Microsoft SQL Server 2005/2008

Open the csv file with excel.