SKYBVI (11/18/2010)

---

I started Sql server in single user mode and then when I try to enter sql server management studio it says:-

Login faield for user 'sa'. Server is in single...

You need to restore master database from the backup

Agree with Roy. Restarting the instance would be a safe idea

The Error number will not be printed in SQL Server Error Logs. Please navigate to Application Event Log, you will find the error number listed there.

I am creating a DBMAIL, I know the smtp server name, can you please let us know which account need to be added to smtp server with what permissions.

AND

I saw...

Cross post. All responses at http://www.sqlservercentral.com/Forums/Topic1022684-391-1.aspx

You can make use of the scripts mentioned in this article to find out when was the database last accessed.

Check if the Job History has any information as to why the job is not proceeding. You may also add an output file to the Job Step to capture more...

You can make use of the Default Trace to track DDL Changes. Please go through this[/url] useful article on SSC.

SQL Server should be started in Single User mode. Hence the -m startup parameter should be used

You need enable NOCHECK on the tables. Check if some of the script posted here are useful.

Are you using the correct Instance Name?

servername\\MSSQLServer does not seem to be a right one.

Yes it is necessary to use 3608 trace flag. This article[/url] in SSC has good information about moving system databases.

You may create an Alert for Error # 833 and configure it to send an email to the operators. Here is an example

USE [msdb]

GO

EXEC msdb.dbo.sp_add_alert @name=N'833Alert',

@message_id=833,

@severity=0,

@enabled=1,...

Secutityadmin members can GRANT, REVOKE, DENY permissions. It has nothing to do with RESTORE permissions. More details here

Minimum requirements:

To backup a database:-...