But if the database is set to be in single user mode then only sysadmin role will be able to login in the database.

Better to script out access to single...

But if the database is set to be in single user mode then only sysadmin role will be able to login in the database.

Better to script out access to single...

Hi, Correctly said by members.

the ideal backup schedule should be

Full backup = Once in week ( preferably on weekends)

Differential Backup = Daily

Transaction log backup = throughout the day (...

If you database is large or having frequently changing data then better to have a Scheduled Transaction Log Backup/

This will help during recovery secenorio.

tried to Executed the script but got the below error :

Msg 102, Level 15, State 1, Line 13

Incorrect syntax near 'int'.

---- Does i am missing something..

Sounds Cool to have titles like.. DTS, DSS, .

BIDS would be more cooler.

Better to have Log backup ( instead of Shrink) when you get an alert for usage of more then 90%.

Kindly provide more information.

1) What is this procedure (GetFileSpaceStats) will return.

2) WHen u r using xp_fixeddrives, why r u using GetFileSpace Stats

3) Try to connect to SSMS and chek...

As "Bhuvnesh" suggested, try Log backup and then do shrink operation.

When you have upgraded from 2005 to 2008, have u register the SPN's manually?

SP3 installation is done on Database level.

It first installes on the passive node then it goes to the active node for installation.

Else Use Book on Line ( BOL) .. It is best help

SQL Server Service should be in running mode. But there should not be any connection to the server for either of node.

Can you copy paste error from SetupBootstrap Folder.

It will throw more light on the error part.

@Ashish

Go to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mssqlsystemresource..

open it on notepad and search your index name over here.

We cannot open the database File ( data or log) in a notepad or any...