History is not maintained once the execution plan is removed from the DMV they are not backed up anywhere. You can however make job that polls the data...

I have had issues like that it turned out to be time difference; check out how long it takes to complete backup. If one of the times the backups...

Make sure your file is saved in uni-code format before you do import; we had similar issues. After making sure the file is saved as unicode using Notepad+ or...

How about using the batching jobs with SQLCMD Variables?

Check out .. http://msdn.microsoft.com/en-us/library/ms188714.aspx

Mohit.

Hmm I have not have backups failed in that manner; if you right click on the maintenance job and check the history with details you should be able to see...

Cross post, replys in link.

Without table structure .. I would have to say this would work for you:

CREATE TABLE #test (col1 INT)

INSERT INTO #test VALUES (400)

INSERT INTO #test VALUES (401)

INSERT INTO #test VALUES (402)

INSERT...

People make sure your executing that against Principle database (aka database that is active).

Thanks.

Mohit.

ahager (3/18/2009)

---

Yeah, it wasn't actually the bulk copy command that I was running at the time, it was a BULK INSERT sql command (I edited my post late). When...

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032402180&EventCategory=5&culture=en-US&CountryCode=US

Thanks.

Erode P. Satheesh (3/18/2009)

---

Sorry guys for replying late. I am on leave.

I am using the below T-SQL Statment,

ALTER DATABASE Mirroring_DB1

SET Partner='TCP://INBGMSNDB01:5022'

Now I am chasing my IT team to add...

Yes it can be...

look at http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/

To understant where there issue can be.

For this table please run

DBCC SHOWCONTIG('tablename') WITH ALL_INDEXES

and reply with the results here. Thanks.

You don't have Trace permissions on SQL Server.

Ask your vendor to execute

USE MASTER

GO

GRANT ALTER TRACE LoginName

GO

Check your job to make sure it is not set to close with failure.

And the last step in the job is configure to return success/failure ..

On your second post it...

Ask your vendor to check default trace log; object drop/creation are logged in there.

And by default up to 5 old trace logs are left.... so there might be...