Scripting out the Jobs is always better

You can not avoid the log from being backed up, however, its amount can be varied. If you take the Full DB backup, then SQL Server will also backup log...

select @@cpu_idle will gv u wht u r looking for.

Check proxy account settings and privledges.

I agree with Mohammad. Anything in the SQL Server is automated through Jobs only. Also, if you can do, create an operator to alert you in case some Job failed.

Good...

It is seemed that you are talking about a replication environment in which the articles are gtting published. If you can provide more details, may be you might get more...

Hi,

Whenever SQL Server can not open anu file required for the proper functioning of the database, it mark that database "Suspect". In your case, as you have already run the...

Hi Steve,

In our production systems, whenever a process keeps on utilizing the CPU, physical IO and/or memory to above a threshold limit, the SQL Server is configured to raise an alert. I...

DBCC DBREINDEX needs 120% more space than the table size. In this space, SQL Server copiers the table, creates tghe index and then, the old index is dropped.

The @@version will always tell the Service pack of the OS installed on the machine. To verify, you can go to the Enterprise Manager and right click on the instance...

In Enterprise Manager, righ click the database and go to properties. In the Option tab, you can find the Recovery Model for that database

Excellent article. It is really well explained.

You should learn the basic concepts of SQL Server clustering before implementing it. How the clustering works and its configuration is extremely important. In clustering, the resources (genrally hard drive)...

Have you restored the database or created on this server only?

sp_change_user_login will surely help you