MSSQLTips

Hi I have a SQL Server 2005 table that is being updated frequently, one of my colleague had deleted the data wrongly. And after that so many updates have been made in the same table. I have a management plan that takes logs backup on every 1 minute. All logs are saved in one of drive. Now I want to...

Steps I need to follow to secure my SQL Server ? Does anybody know how to secure SQL Server ?

Hi I need to restore the SQL 2005 db backup on SQL 2000. I had changed the compatibility level of SQL 2005 database to 80 & then took the backup. Now I am trying to restore this SQL 2005 db backup on SQL 2000 but an error occurs while restoring i.e. 'Too many backup devices specified for backup...

I wanted to know if we can automate the SQL process at particular time everyday sending an email with Excel Document attachment. I have a SQL Statement which will provide a particular result, which I want to see and would like to email directly to xyz, abc person automated process in excel format. Please...

Is it possible to monitor user's activities in SQL Server 2005 e.g. which statements he or she has fired and all the activities he or she has done in his or her session.

How a schema can be useful in MSSQL 2005 ?

How to truncate log file in MSSQL Server 2005 ? How to take backup of log file ? My log file is full with 2 GB, how can I take backup of this log file ?

I have a database of 1 GB. When I take full backup, the size of .bak file is very less than the actual size of database. I want to know how does this size of database in .bak file get reduced. Which mechanism MSSQL Server uses to do this task?

Things to be keep in mind before and after creation of MSSQL database. This is what I want to know. Thanks in advance.

Hi Can anybody tell me, the things to be kept in mind of pre & post installation of SQL Server 2005 ? Any suggestion would be highly recommended.