taking decision to use the SQL version is totally depend on your enterprise requirement.

like database size,user connections,implementation of high availability mechanism...

check is there any index rebuild job running daily

yes cain is described all the possibilities of it ...u need to check it one by one

-did you found any error while debugging

-what is the version of SQL server

you used the system keword while renaming the table thus it is not possible to revert,script out the exisitng table,create new table and import data.

need to create logins of restored database user and map it

If you r beginner for MSBI, learn this 1 by 1 like

complete the topics of SSIS....then SSRS..and SSAS or arrange it as per your choice

use Microsoft SQL Server 2008...

Recreate the profile once again .....restart the agent and check

1. Telnet your mail server with smtp port and check whether mail server available or not

2. confirm once again whether database mail is started or not with EXEC msdb.dbo.sysmail_help_status_sp

3.if...

Compressed backup file is a OS physical file which is restore normally like any backup file while restoring database, there is no such a thing like uncompress backup file.

http://www.sqlservercentral.com/Forums/Topic1107587-360-1.aspx

Hi SQLBuddy...Thanks....for replying...

I have taken sunday downtime to implement it...lets see

Total Srv memory :cntr_value =1661808 and cntr_type = 65536

OS version is :-Windows server 2003 R2 SP2 Ent.edition

I am not getting on :- lock pages memory to the sql account,can you pls describe it more

as when i seen in...

sorry for delay to say .....Thanks

it really helped me.