Below are the methods to find the Port of SQL Server

1) From the errorlog. I.e sp_readerrorlog

2) From the Client protocols of configuration manager.

Ok accepted Shaw

If you check the created date i think restored database will be the recent date but attached DB date will be old date.

Looks it is storage issue. Check if there is any error belongs to Msg 823. If it is then work with storage team. If there are no data files expect...

Shaw,

I think below one is also one of the differences what do you say?

Restore will create the new database and Attach will just create the existing database.

Thanks in advance for...

Yes, we can rename the instance by using the below commands. I have also involved once in this activity.

sp_dropserver 'old servername'

go

sp_addserver 'new servername'

go

We can find out the issue by following below steps.

1) Check the error log.

2) We can see few errors in SQLAgent.out

3) Check whether Agent XP is enabled...

We can also determine whether there are open transactions or not.

select log_reuse_wait,log_reuse_wait_desc, * from sys.databases

check the log_reuse_wait_desc if there is any cross verify with dbcc opentran(). If there are...

After executing the below 1st command, we got the list of orphan logins, it listed out and i selected one of the users to auto_fix. But unfortunately it throws below...

Thanks Shaw for your input.

Thanks Shaw for the information. I understand your point on file groups and my misunderstanding.

I would like to share one of my views on files i.e. same file (with same...

I have added the new file group called Secondary in one database and i have added one file in that file group.

I have done the same in another database.

By this...

Generally it is because of Blocking, space issues, IO issues, Index maintenance (Fragmentation), Update stats,High CPU Usage, High Memory Usage.

Check the execution plan of the query and confirm whether...

Hi Everyone

I got a request to delete all the logins except service accounts. So is there any script for working on this?

I tried above one but there is no luck

Advance...

Primary server's service account should have write privileges on the backup folder and Secondary server's service account should have read privileges on the backup folder.

Let any one know if i...

Could any one confirm whether my below statement is correct?

TCP Port should be dynamic in cluster environment and it should be static in stand alone.