ps (7/23/2009)

---

I'd agree with Steve's concern of backup up your database in a single file by appending files to it. If something happens to the file, none of the backups...

I dont think I am appending.. the option is greyed out (see attached image)

I agree though.. geez.. sure hope I'm not overlaying backup files.. i didn't think I was anyway.....

ah I see what you're getting at.. sorry im a bit dim some days..

It does show that it failed, and why.. unfortunately

Task Detail: Backup Database on Local server connection

Databases: myDB

Type:...

I tried the view history, it was truncated.. that was my problem. I'll check those tables out tomorrow morning.

Thanks

SQL DBA (7/22/2009)

---

Also make sure the maintenance job is running with a job owner who has all sysadmin rights . At times the owner may get changed in job &...

Steve Jones - Editor (7/21/2009)

---

The logging is trivial to set up in the plan, and there is a task to delete old logs after xx days.

You should have this running....

Nope. Single database...

Would it not have been easier to just say its a varchar field, the same as all the rest I'm using, rather than dragging the question out across multiple posts?

I...

mathewspsimon (7/20/2009)

---

I have a ERP which is running on Oracle and a retail application which is in SQL Server.Oracle has the Employee information and I have created view which...

ok my first question would be why are you crossing platforms? Perhaps there is a better approach you can take.

What datatype are the two columns within Oracle that...

mathewspsimon (7/20/2009)

---

The qoutes in Sandro is because I am executing the query in SQL Server and I guess that is the syntax for that.Also the same query when I run...

I was hoping this information would be stored off in a table somewhere.. the logging is a pain because its so random when it fails..

oh well..

Thanks

ps (7/20/2009)

---

Can you see the backup file even after the job fails? If yes, can u verify if it's correct? If no, can u check disk space? May be its...

sku370870 (7/20/2009)

---

I am storing some text in a text field that is, essentially, a pro-forma letter. The text contails html formatting.

When the text is retrieved it is placed in a...

mathewspsimon (7/20/2009)

---

Hi I have the following issue when I try to access data from Oracle Database.

SELECT * FROM OPENQUERY(CIDEV,'

SELECT PREVIOUS_NUMBER, GIVEN_NAME, MIDDLE_NAME, EMAIL_ADDRESS, MEDICALLICENSEHAAD

FROM XXHR_EMP_DETAILS_INTEGRATION_V...