Yes it's a permission issue. Try to run the SSIS package using Agent SSIS proxy using your ID as credential.

--

SQLBuddy

Mangesh Raut (3/18/2014)

---

I have added the logging and no error is coming in the log file. This is the same package I have deployed on the another server (Development) where...

zedtec (3/18/2014)

---

In relation to this, what happens if one of the site's goes down (i.e - the principal site) and automatic failover is not being used (i.e. - there is...

That's a permission issue. You need to have Admin privileges. Or at least you should one of the following : My Reports\ Publisher \ Content Manager.

Ask you SSRS admin for...

If it's for High Availability\Disaster Recovery purpose, use DB Mirroring.

MS Synch is used when there are distributed\mobile clients.

--

SQLBuddy

glugingboulder (3/17/2014)

---

Thanks for reply, i understand that part, but what if you have this example.

10 node windows cluster

Availability group 1 spans nodes 1 -5.

Availability group 2 spans nodes 5-10.

Essentially you...

It depends. What's the actual requirement ? Is it providing High Availability\Disaster Recovery or for providing data to the remote disconnected clients ?

--

SQLBuddy

You should set up PARTNER TIMEOUT for the DB mirroring to be greater than the time it takes for the SQL Server Instance to failover from Node 1 to Node...

Yeah, That's the limitation imposed by the architecture of Always ON itself. So even though you have 10 nodes, each AG can have 1 Primary replica and upto 4 Secondary...

Also make sure your script those indexes \ backup the database before dropping them. If you have issues later bcs of dropping, then they will come handy.

--

SQLBuddy

msmithson (3/14/2014)

---

My company recently migrated to new hardware. The decision was made to create a database file per core per filegroup so now the database is spread across > 80...

Yeah they are different. You need use the DB according to SQL Server Version. They have them from 2005 - 2012.

--

SQLBuddy

I was just answering to 2 Qns. Should have mentioned the approach too.

Keith Tate (3/14/2014)

---

You may want to take a snapshot of the wait stats right before you busy...

No it's won't be of any good use as you are doing this Off-Hours .. You should try to get metrics during the busy part of the day to have...

sqlbuddy123 (3/14/2014)

---

Do you have any Application Jobs\Processes running during this period ? Start a server side profiler trace by appling filter on that DB and App ID and see what's...