Tables and indexes are both...

This is a SQL Server forum, not MySQL. Try http://forums.mysql.com

Please note: 5 year old thread.

DECLARE @string1 NVARCHAR(1000)

DECLARE @Output NVARCHAR(15)

SET @String1 = 'select @item = MAX(backup_set_id)

FROM ['+@server_name+'].msdb.dbo.backupset

WHERE database_name = '''+@db+''' AND type = ''D'''

exec sp_executesql @string1, N'@item nvarchar(15) OUTPUT', @item = @output OUTPUT

select @output

The format for sp_executesql is:

exec sp_executeSQL @SQLString, @ParameterDeclaration, @Output = @Variable

Exact details in Books Online.

Without seeing what you're doing, that's about the best I can offer

Maybe take a read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

As for what's causing the log to grow, well, first you have to identify why it's growing. See referenced article. Once you know what...

SQLCrazyCertified (4/8/2013)

---

GilaMonster (4/8/2013)

---

Neither.

Overwrite would be rather silly with log backups since you need all log backups in sequence...

sqlpadawan_1 (4/8/2013)

---

To clarify a couple of points. The variable is being used as a constant in the code. @yes will always equal 'Yes'. Rather than have a...

Basically the difference between the two comes down to parameter sniffing. At compile time the optimiser can see the value of the constant and can compile a query plan optimal...

j.miner (4/8/2013)

---

2 - The plan with the variable will be recompiled every time. This is due to the fact it might change.

This is even more likely if the input...

Neither.

Overwrite would be rather silly with log backups since you need all log backups in sequence to restore....

Parameterised vs not parameterised. (though you can prepare a statement with hardcoded values in it 🙂 )

I seem to recall, maybe that DBCC Loginfo gained an additional column in 2012. Check that, run DBCC LogInfo by itself and see how many columns it returns. If there's...

The entire IO subsystem, from the filter drivers down to the disks. Corruption is 99% of the time an IO subsystem problem, could be anything in the stack. Check the...

So the full backup is reinitialising the log chain and hence the log backups run. It's not a good maintenance schedule though. Switching to simple recovery for index rebuilds is...