Thanks lot Loner and Gila,

After the changes done as per your suggestions, it works well.

Again thanks...

Warmest

Jai...

Hi Loner,

Here i need to specify one more details, dash_id is a less selectivity column (28 rows) and total rows of the table is 98886.

Here can we add the dash_id...

Really thanks for your thoughts, I'll review the same and correct accordingly.

Yes, first use RESTORE HEADERONLY to ensure that the backup returning header information of the backup file. If needed use RESTORE VERIFYONLY, because it may take more time to...

Hi,

Not necessary to take the database in simple recovery in all scenarios. If the backup not properly scheduled for the database, take a full backup and directly you can shrink...

Direct  Solution is recyle the MS SQL services and try to connect with the client/server OR the DC must be refreshed with the SPN.

The reason behind is when you change...

Openings Only in India

Package will be based on your technical experience and current package...

Yes, as Norene said, you should backup the Tlog.

When you want to shrink the Tlog file? : If the TLog file occupying more physical space on the drive also...

As Lucky said, find an another specious disk and RESTORE the database with MOVE (MOVE 'logical_file_name' TO 'operating_system_file_name) option that will help to move the data and log files in...

If the Drive has enough space, you can give UNLIMITED in the maxsize or in the same drive if you have many database data and log files you can restrict...

Try this also,

do the DBCC CHECKDB, note the correupted table, then move other tables to a new database using DTS tool. Then try to DTS the corrupted table alone, there...

The following points needs to be kept in mind before install SP2.

1. Keep enough space on C$ drive. (like 1GB)

2. Keep the TempDB to grow as well (keep maxsize in...

DBCC CHECKIDENT will help you well.

There are several reasons to fail a RESTORE. When you're doing a point in time recovery,we need to apply all log files after the Full/latest Diff backup. Have to apply...

Hi Shah,

Post the error details, that would help to reach the target easily. As you said, while restoring the Tlogs it is throwing err. Check the following.

1. Verify the First...