When possible I prefer to copy the BAK file to a local or SAN drive before restoring. I wouldn't trust a network connection for this operation, expecially with...

The "Key" items...

Try using the GETUTCDATE() function to determine the actual time to decide if it's time to eneable the job, as in:

IF GETUTCDATE() > '2013-11-03 06:00:00'

/* Adjust the time...

Sometimes a stuck or orphaned transaction will prevent the log file from overwriting inself and cuase ti to grow indefinately. If you suspect this is happening, you can run...

FYI, I have confirmed on two different instances of 64-bit SQL 2008 R2 SP2 that WITHOUT Integration Services installed you can run an SSIS Package from SQL Agent that imports...

I'd say about 76GB If you're using SQL 2008 Standard Edition (maximum this edition can use is 64GB). If you have enterprise, then as much as your hardware...

Does this not prevent use of xp_CmdShell by SAs, which was the original quesiton?

This reminds me of a question a few years ago about how to keep SAs from being...

Not to interject a dumb quesiton into this but what does this mean?

nameminimummaximumconfig_valuerun_value

xp_cmdshell0100

Since no one would hire a DBA with zero experience, I'd say that ALL DBAs start via the accidental route. When do you become a REAL one? I...

Here's a pair of excellent articles on installing SQL Server:

https://www.simple-talk.com/sql/database-administration/provisioning-a-new-sql-server-instance-%E2%80%93-part-one

https://www.simple-talk.com/sql/database-administration/provisioning-a-new-sql-server-instance-%e2%80%93-part-two/

When you get to the screen where you select features, select Reporting Services only (on the Reporting server of course).

When you...

Thanks!

Acutally, since the connection string format for ACE.OLEDB 12 is more than just the filepath the actual value I needed was

"Data Source=C:\\Folder1\\Folder\\" + @[User::Site]+ ".MDB;Provider=Microsoft.ACE.OLEDB.12.0;"

Now I'm progressing.

I was planning to install Integration services during the last downtime when I can across this:

http://technet.microsoft.com/en-us/library/ms345193(v=sql.105).aspx

But from what I'm gathering, there's no need to configure integration services service as...

I swtiched from the Jet provider to the ACE Access 10.0 provider, but I'm havng the same result: The data from the text source file successully imports, but the...

Koen Verbeeck (10/18/2013)

The package was...

Koen,

I'm a little farther into this project, but I'm still confused. In the blog post you linked to earlier, you wrote

You only need to install Integration Services...