Search this site (or elsewhere) for "simple recovery model" and read about recovery models and backing up the transaction logs. One of the things you'll notice is that you...

SELECT recovery_model_desc

FROM master.sys.databases

WHERE [name] = '<InsertYourDatabaseNameHere>'

As for backing up the log, I imagine that if you don't know whether you do it, then you don't do it. When you...

Right, so if I understand correctly, you are restoring a database from instance A to instance B? Does the user SVCREMOTE exist in the database on instance A? ...

Yes and yes. There are certain commands that will truncate the log without backing it up. I suggest you go to the link that Jason posted - I'd...

Looks like you have an orphaned user in your restored database. Remap it after the restore with the ALTER USER command. The syntax is something like this (I'm...

Oops! Duplicate post.

You can probably do this without a cursor, although it would be messy. However, this kind of display formatting is better done in the presentation layer than in the...

Is your database in Full recovery mode? How often, and when, do you back up your transaction log?

John

But what was quoted wasn't the whole solution. See my first post...

Yes, there almost certainly is a better solution. But you haven't posted any DDL or data for EVENTS, so we can't offer you any tested code. A good...

On a default Windows installation (depending on the version), it's C:\WINDOWS\system32\drivers\etc\hosts. But you didn't need to ask me that - you could have just typed "hosts file" into your...

In the Derived Column Transformation Editor, there's a list of date/time functions. Pick one of those. If you're unsure of the syntax, use a search engine - there's...

Ask your network people whether there's a DNS alias set up on the DNS server. alternatively, have you checked your hosts file to see whether there's an entry in...

Have you checked the sqlagent.OUT file? That will tell you why it's failing. If the file doesn't exist, or the date on it is older than the last...

Create a new data flow and use a derived column transformation to split the date into its constituent parts.

John