Hi lipi,

u can go for BOL

http://www.mssqltips.com

http://msdn.microsoft.com/en-us/sqlserver/default.aspx

https://www.microsoftelearning.com/

technet.microsoft.com

http://www.sqlservercentral.com/articles/Administration/sqlserver2005bestpractices/2183/ 😛

cheers,

syed

🙂

EXCELLENT article Sachin,keep it up.

u have just simplified a complicated task ,before reading this i was totally unaware of inplace and side by side upgrade techniques,now it is clear to...

:P[font="Arial Black"][/font]

see there is no way to restore transaction logs in single T-sql command,

any how we have to first restore the fullbackup with no recovery:)

then apply all the t-logs...

TEMP DB FULL:

first know the reason why it is full then shrink the...

🙂

DIFFERENTIAL BACKUP: it is the backup of databse since last full backup.

so if u r having many differnetial backups u have to go for the only latest differential backup...

Hi,

without profiler the only option...

EXCELLENT...:w00t:

IT WORKED 🙂

Thanks,

Syed

If your client and server are connected to the Internet, you can use the Internet to connect to an instance of the Microsoft SQL Server Database Engine using SQL Server...

full recovery model ---mdf,ldf

bulk logged ---mdf ,1/2 ldf(partial )

they work in the same way but for bulk operations there is...

Thanks Hari,:)

i googled and came out with 1 solution we can use REPORT tab in SSMS which displays all the queries and identifies the particular one with poor...

waht i want to ask is that so many queries r running i cant view estimated query plan for all,

is there any way from MMS to know that ...

Thanks u are right:)

use redgate backup tool and have the complete database backup

A differential backup is just a backup of the changes made in the DB since the last full backup.

your backup startegy should be

FULL BACKUP - WEEKLY

DIFF BACKUP -...

take backup of T log with this option.

WITH TRUNCATE_ONLY