Excellent scripts... It was really helpful 🙂

Hope this is not production environment where you are trying to delete 2nd log file.

On following the steps given by Steve (backup the log, then shrink the one you want...

I got it right in first shot. I had come across similar situation 🙂

I am in the similar situation. I am upgrading my skills through forums and keep myself as current as possible. Simultaneously looking for better roles 🙂

Hi Henrico Bekker,

You are right and thank you for the link.

I understand it is not straight forward to provide answer for this requirement. I just wanted to check approximate CPU...

Try the following command to check exact disk space required to restore .bak file (Add up size column) and its physical file names.

RESTORE FILELISTONLY

FROM DISK = 'CompletePath_DBName.bak'

I got it worng no dought it is a good question 🙂

Nice question, I got it right 🙂

Hi Ratheesh,

Post says, SQL login (SA) was disabled and he was not able to login using Windows Authentication since it is deleted by oversight (The way issue raised is bit...

Hi Ratheesh,

On which version of SQL server did you test this? In SQL 2008 you can not save sa password and MS has confirmed it as bug and they are...

Hi Vijayanj

By default SQL Server does not allow you to save sa password. (Though check box to save password is enabled)

Try to login as any other SQL user and save...

Yes… Now I understood your issue. From the screenshot, I can make it out that you are logging as SQL user but not as Domain user (Eg: Domainname\Username)

Try logging...

Right click on Expand security -> Logins ->Right click on the domain user account -> Delete

This action will throw information/confirmation window as shown in attachment

Once you click on OK, it...

Hay Steve,

It is sounding very strange!!! Is this issue is with only database or is it happening to all databases across the instance? BTW, which version of SQL server...

As per Microsoft this issue occurs when SQL Server system administrator account name is changed. The Configure Distribution Wizard requires the account name to be sa.

Also, MS suggests upgrading MSSQL...