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.

Enabling the named pipe did the trick.

I have thought about setting the notification for successful runs but...

Thanks for the reply all but the problem has been solved.

The only thing that I couldn't understand was that the user I had created was not able to access...

Jeff Moden (12/7/2015)Ok... let's just say that you get a script working to do such a notification for your index rebuild job and it sends you an email that the...