I am Introducing a Delay of 30 Seconds for Trans Log BackUp between each databases.

Will this be a correct Solution.

Hi Steve,

The Full & Tans Log BackUp(Both together) go to a different SAN Drive apart from the SQL DATA & Log Drive(Which has a separate SAN Drive for each).

Also the...

Thanks a Ton for your Help....!!!!!!!!!

I was able to successfully move the Non Clustered Indexes to another FileGroup.

How to check whether the data is on which FileGroup.......

Is their any way of finding this out..........

If Suppose I move the Non Clustered Indexes on PK's to another Filegroup..how will...

Thanks for your reply Ninja...........

So does this mean that moving the Non Clustered Indexes created on PK's,Unique Constarints,FK to another Filegroup won't actually move the Data....The Data will remain on the...

Hi All,

Thanks for the Replies........

I have moved the Non Clustered ndexes apart from Unique Constraint and PKs......to another Filegroup

Now I have a Problem .....whether moving Non Clustered Unique Constraint...

Hi All,

I wanna a Script that will script out all the Non Clustered Indexes on all the Tables in a Particular database.

Also if available Please send me the script of...

Hi Greg,

Thanx a Ton for the explanation...!!!!!!!!

I need one more help from you if you can let me know where i will find the Best Material for SQL Server Architechture...

I try to make it simpler, Mine question is if you take a Full Backup of a database and after that if you take a differential Backup....

How would SQL Server...

Thnx David......

But My question is why can't we take the Transaction Log Backup in Simple Recovery Model.

Its Just Like a File with name.ldf and why we cant backup this File.

Thnx...

Hi ALz,

Thnx for the Script.I applied the Most recent Backup and after that the Differential BackUp and the Transaction Log BackUps after the Differential BackUp and then both the Databases...

Whats the Replication Cycle...I haven't setup the Replication but both the databases are the Log Shipping Pair

OOps sorryyy i Forgot to mention due to newtowrk failure last night their was no connection between the two servers for 4-5 hrs and thats why both the databases are...

Hi,

You can Bring the Database in SIngle User Mode by:

USE masterEXEC sp_dboption 'pubs', 'single user', 'TRUE'

Then After this stored Procedure you can detach the Database.

Hope so this Helps you....

Hi Rai,

My First question to you is Why do you want to restore the master Database?Is your server Crashed OR give the Reasons for restoring the Database?