How has this site been detrimental to you? I find it useful.

Wow. I love it when I finally figure out something that's been driving me nuts all day.

I kept getting an extra empty file out of the Raw File Destination when...

Anyone else find it inconvenient that MS wants people to have SysAdmin access in order to work the sp_enable_sql_debug proc correctly?

https://connect.microsoft.com/SQLServer/feedback/details/351698/msit-mso-debugging-sql-query-fails-with-an-error-the-execute-permission-was-denied-on-the-object-sp-enable-sql-debug

I've just started running into this issue myself. I hope...

Okay, so the Recordset Destination is giving me fits. I've never used it before and am having trouble figuring out how to use it as a source when I go...

There are days when I wish I could.

Thank you for posting your fix. This will help other people.

preetid2 (5/23/2012)

---

oh, ok Steve. so , if i don't have the previous file in the exisiting the folder, since there's no file exists my next backup will create the...

Ah. Pipes. I didn't even think about that.

Most of what you said is what I've been thinking, but you said two things that hadn't yet occurred to me. Thanks.

It would help, in the future, if you post that you have tried Google what results you've gotten. We have too many users here with errors like this that don't...

There is a difference between the .bak file and the backup device. SQL Server needs an object called a backup device to which it passes the backup data. The backup...

You could check out Replication or Snapshots or just INSERT the data from one db to the other (and add the date to the SELECT list).

Or you could look at...

Try this one:

http://stackoverflow.com/questions/5554088/reporting-services-2008-the-report-server-installation-is-not-initialized

And try googling your error. There are a lot of possible solutions out there, it just depends on which one is closest to your actual problem.

In my office, we unfortunately know more about the business rules than our business users do. Additionally, there are too few...

Check out this MS technet page:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1c489009-40b2-4b5c-bf5a-6d41c9e1e775

The only other thing I can think of is whether or not your services are running under domain accounts or not. Have you checked that?