Fortunately QA

The transaction log for database " " is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

We don't take xlog backups.

I was a biology major but just became a DBA last year. I am going to be honest with you, people love it when you are upfront and honest. I...

We have a client and they are 24/7 shop. We take our backup around 1 am central time (US/Canada) but we also have users accessing the DB from UK and...

Virtual and backups are run by 3rd party tool (Veeam).

sqlbuddy123 (2/25/2014)

---

Yeah, though abt backups. But again felt that if it was backups then that should have been a recurring daily issue. Not a one time one ..

That's where...

I just received an email saying that "The backup was running at that time, which could have froze things up for a moment".

I don't think the service was restarted since I don't see anything in a log.

DB server.

I checked the application log but I don't see no error. It's either warning or information.

I RDP into the server. Went to event viewer->windows log-> application. Is this the right place to start looking for errors?

Well I can ask them but how do I even know if its a DB issue? How do I check the log. The log I posted, it was sent to...

The application disconnected from the DB and we received a message stating the DB was unavailable last night.

[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (SQL Server 11)

Tue...

Now I got it, Thanks

SQLRNNR (2/21/2014)

---

Try dropping the batch sizes down.

Also, are you loading the table as the source or are you loading it via a tsql statement?

Sometimes SSIS likes (ok a lot of...