Tag Info

New answers tagged

1

There can be many reasons for that. You're queries run and generate a version, during another query use the same tables. During this phase version 1 will be hold back. If your transaction isn't commited at the end, it may occur that version 1 will last for a long time in your tempdb. Make sure that all transactions are probably commited and closed. Make ...


0

First verify if what you're seeing is a direct representation of your current server by typing this: use tempdb go sp_helpfile If you see it here, you somehow created it there by accident. TempDB is a 'special' system DB in how it get's generated and all the finer details escape me at the moment. Setup TempDB the way you want it, restart the server so ...


4

NOTE TO READERS: Please read the entire question, including the example code (i.e. not just the title). This question is not about how to best cycle through databases, nor is it about why does [tempdb] receive this error. The O.P. is already trying to avoid executing the ALTER statements on all system databases (well, the 4 visible ones) and is asking why ...


3

Apart from the fact that you cant change the recovery option for tempdb, You dont need a loop for what you are doing : Run in SSMS by pressing CTRL+T select 'alter authorization on database::' + quotename(name) + ' to [sa];' + char(10) + 'alter database ' + quotename(name) + ' set recovery simple;' from sys.databases where database_id > 4 and ...


3

Msg 5058, Level 16, State 1, Line 5 Option 'RECOVERY' cannot be set in database 'tempdb'. It does the job it's supposed to do. But I am unable to think of a reason for the error. First of all there is no need to use ms_foreachdb its undocumented and way bad you can loop in using simple cursor. Regarding error you are trying to change recovery ...


3

File writes are distributed across files in the same file group proportionally based on the current size of each file in the file group. This is referred to as the "proportional fill algorithm" - look at http://sqlserver-performance-tuning.net/?p=2552 for some interesting details around that. tempdb can have only a single filegroup. If you attempt to ...



Top 50 recent answers are included