Does a full backup will help to decrease the size of the log file in MS SQL 2005?

I have a simple question, sometime I see different extensions on MS SQL 2005 backup like : bak,. trn, .full What is the difference between them? Thank you.

How security is set on drives of Windows Server 2003 to let only specific SQL Server Instance acces to them? For exemple: - Windows 2003A, has SQL Server 2005 installed with instance01 and has those drives: C, D, E,F - Windows 2003B, has also SQL server 2005 installed and SQL Management Studio Mixed...

Good Day i would highly appreciate if i could get some advise on how to see which user has run which scripts on the SQl database. i have multiple users connecting to a server and there is some users with write access. i need to trace the user and what last scripts they have run, as incorrect script has...

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Tabla normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:"";...

I have a production SQL Server 2005 SP2 instance hosting over 150 databases. Every day or so the server performance slows considerably for all SQL services. Upon inspection I see a dozen or so threads of ‘UPDATE STATISTICS’ running with many in a wait state. If I kill the sessions(s) running the statistics...

Hi I created a view in a development enviroment and migrated the same view to the test environment. The view works in dev but not in qa. can anyone tell the reason and where I should be looking to trouble shoot?

Hi all, I am looking to optimized my query, i request you all to please help me on this. My requirement is basically to get all the duplicate records from the table Contact that has atleast 1 duplicate contact no in any of the column mentioned below (the columns mentioned below are basically home phone...

Hello Friend I've just registered me, 'cause you help, it works for me also Well, i applied in the ms_foreachtable statement, something like this hope this will be useful for someone =D ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DECLARE...

Hi guys, Is there any way to find out if the sql server is used by a third party program (such as ms office ...) please? Any suggestions appreciated. Thanks,