There are several columns in your destination table that don't allow NULLs. Therefore you need either to specify values for those columns when you insert a row into that...

I think you need to change the LEFT JOIN to an INNER JOIN, but without DDL, sample data and expected...

Chris, are you sure about that? Referencing a column from the outer table will turn an outer join into an inner join if the reference is in a WHERE...

Also, I wouldn't recommend rebuilding with a blanket fill factor of 90 (or anything else). 90 is often a good choice, but not always - for example, if the...

No. We're volunteers, and we're not here to do the job that you're paid to do. We're all perfectly willing to help out if you've made the effort...

Satish

Since the script doesn't have "7zip" in it, it's not going to get you very far. Search for "7zip command line" to get the syntax. How are you...

What script have you tried? It's quite easy to use the 7zip command line.

John

Is there any reason you can't schedule your full backup as well? It's correct to say that you can backup with users on the system. However, given that...

You certainly need to investigate why a database of that size has a log of that size. My point was only that if it won't truncate automatically, it won't...

The easiest way to do that is just to wait and the log will be automatically truncated for you. You shouldn't have to wait more than a minute for...

Here's one thing you can try:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/fe402094-d218-4b6c-b7a4-f45b2d604cb1/

If that doesn't work for you, do what I just did and copy that error message into your favourite search engine. There's plenty of...

I think that option is available in SQL Server 2008 but not 2005. If you have cluster resources and groups left over, have you tried removing them using the...

If you can't or won't correct your design as suggested by Joe, use the MERGE statement as suggested by Sandeep.

John

Sourav

I'm not quite sure what you're doing with your completion_Status column. You're returning 'Completed Full BKP' if the backup (of any type) is more than an hour old, and...

Definitely worth checking, yes. When he said "the job consumed 73GB", I wanted to check that it wasn't just the case that the file ended up at 73GB due...