We are restarted the system. Now the SQL Server is up and running

What will happen to the SQL Server if they restart the system?

I am getting the below error

Can't open the file. This may be because the file does not exist, is not an MMC console or was created by a...

Currently, I can't able. Not able to RDP.
I tried to start the agent but it failed telling it has dependency service. I have to wait for the server admin.

Thanks for the reply. Let me give you some more details.

We have the maintenanace plan created around 3 yr ago with SQL 2005. We migrated to 2008 R2...

Yes. Almost same size just some kb difference for some databases.

First thing is there is no change in backup job either schedule or any other change.

I can see there are two backup files in the backup folder for each database...

Yes. I am the member of sysadmin in all instances. But when I restored a database in other instance, after the restore it will display my login as database owner...

I am sure, I was not logged as sa.

Hi,

I noticed in one instance when I restored the database using different server backup, after the restore the database owner is sa. But when I created the new database the...

I want to make it as default not manually run the command.

Thank you.

Instead of

select name, suser_sname(owner_sid) from sys.databases

I enter

select name, suser_name(owner_sid) from sys.databases;

It is working fine

Thank you.

I figured the issue.

We have two instances one is native & another is named.

It worked, when I used http://localhost/Reportserver_instancename.

I have another question, will there be any...