The RESTORE command has to execute on the instance where the database will be restored. I would recommend using PowerShell for a job like this. You can use the SQL...

If you set the BATCHSIZE to 1 on BULK INSERT you'll get the rows from the file into the database in the order they appear in the file. It'll be...

https://connect.microsoft.com/SQLServer/feedback/details/775884

jl-820778 (1/4/2013)

---

Thank you for your clarification and link. It's very helpful.

Now, I'm getting convinced that db_owner is the right one to give but still have some dilemma. From time to...

I was typing while you guys had two more responses, sorry if my last post seemed redundant.

From the resource-list it looks like you might have things accessing resources in a...

Here is the prepared SQL from one of the processed shown in the graph (re-formatted by me). Does it look familiar?

(@P1 DECIMAL(15, 6),

...

dbo is...

What you want to do is add the Database User as a member of the db_owner Fixed Database Role:

USE YourDatabase;

EXEC sys.sp_addrolemember

@rolename = N'db_owner',

...

Evil Kraig F (1/4/2013)

---

opc.three (1/4/2013)

---

The way I am viewing it is that SSIS will try to use a file regardless of whether it can gain exclusive access to it or...

Get-TSCurrentSession | Get-Member

Look at the SQL Server Error Log to see how long each step in the creation of a new database took. Post the messages here if you have doubts.

Evil Kraig F (1/4/2013)

---

opc.three (1/4/2013)

---

Evil Kraig F (1/3/2013)

---

Agreed. I was not saying the code you showed doesn't have a place, only that it is more prone to having a problem...

See the section "How to Check if Instant File Initialization is Enabled" here: http://www.johnsansom.com/sqlserver-instant-file-initialization/%5B/url%5D

Perry Whittle (1/4/2013)

---

During a restore the database engine is laying down the data pages from the backup to disk, this is not instant file initialisation!

Instant file initialisation will be noticeable...

Upgrade to SQL Server 2012? catalog.start_execution (SSISDB Database) Let me guess, not a likely option.

You are right to deny access to xp_cmdshell, ideally disabled. SQLCLR is a recommended replacements for...