All DBs are online and in sync

This was the error in the log file

AlwaysOn:...

Eirikur Eiriksson (6/9/2016)

---

Chitown (6/9/2016)

---

All, wondering if I can get some help? I am trying to find a script which can help me accomplish this task. I am trying to have...

GilaMonster (6/9/2016)

---

I foresee failed backups and other maintenance tasks in your future, possibly heavier server load as reports are run again and again as they keep failing, and irate users....

Finally resolved. Missing some double, triple quotations....

Select

'RESTORE DATABASE ['+name+'] FROM DISK = N''\\dd-database\database\SQL\prod\'+name+'.bak'' WITH FILE = 1, MOVE N'''+name+''' TO N''D:\Program Files\Microsoft SQL Server\MSSQL10_50\MSSQL\DATA\'+name+'.mdf'', MOVE...

Maybe close but close enough

Select

'RESTORE DATABASE ' + QUOTENAME(name) + 'FROM DISK = N''\\dd-database\database\SQL\prod\Voxco_2008R2\SS-VX-SQL1' + name + '.bak''

WITH FILE = 1,

MOVE ' + name +...

Lowell (5/17/2016)

---

Sean Lange (5/17/2016)

---

You will become familiar with both the backup...

I am actually getting close.

Select 'RESTORE DATABASE [' + name + '] FROM DISK = \\database\sql\prod\[' + name + ']\;

'

FROM sys.databases

;

We already have a full backup in place from this weekend.

Select 'RESTORE DATABASE [' + name + '] FROM DISK = (Backup location);

'

FROM sys.databases

I figured out half of...

I have learned how to stay calm. Even though it felt like a lifetime, I scripted it out, restored the full backup and dif and no TLOGS. Took forever but...

I will personally kick his/her butt :-). Since it's prod, no one is...

Hugo Kornelis (3/31/2016)

---

1200 logical files? That is a lot!

I recommend using this opportunity as a test case to check how long the restore will take. Then compare that with the...

TheSQLGuru (3/31/2016)

---

This is the third time I have mentioned this this week, but you must make sure your non-production environments have Instant File Initialization enabled. Otherwise your restore will zero...

Yes. The last time we patched all servers was last week.

Getting close

drop table #test

create table #test (command varchar (500))

insert into #test SELECT 'USE [' + name + N'] '

+ 'CREATE USER [innem.sa] for login [innem.sa]'

FROM...

Thanks for the response.