Are you using SQL Server Express edition?

Only in SQL Server Express edition, AutoClose is ON by default.

When the last user exits, the database is closed cleanly (data and objects...

Are are you saying this concept...

Enable remote connection to this server.

By default remote connection is...

SQL Server 2000, automatically creates schema with users name if the user is not member of db_owner role.

SQL Server 2008, by default creates objects on dbo schema.

As for as physical I/O...

In addition to BATCHSIZE there are few more conditions for minimal log to occur. For example, TABLOCK option also should be used.

Please the BOL for more details.

Also note that, it...

User is disabled (in the database level) by revoking CONNECT permission.

USE <database>

GO

REVOKE CONNECT FROM <user>

GO

crazy4sql (1/18/2012)

---

ok, so then how sql come to know while restoring the database that it need to add the specific amount of free space in database files and as exact...

Just data. No free space of DB.

You can use Profiler for this purpose.

Check whether AutoClose property is ON for this DB.

I have a question for you.

Did you face this question in an interview for SQL Server DBA position?

mariobehring (1/17/2012)

---

...

2012-01-17 14:40:48.318 Status: 0, code: 20015, text: 'Login failed for user 'MSIGA'.'.

2012-01-17 14:40:48.318 Login failed for user 'MSIGA'.

This MSIGA user has all permissions possible inside both SQL Server machines,...

Looks like it is NOT SQL Server backup file.

I suggest following:

1) Check the SQL Server error log. Verify the entries related to backup. Are there any errors? Notice the backup path\filename.

2) Increase the length of @FileName to 1000

3)...

If you execute the following on SSMS query windows (not inside trigger) on Server B, does it work?

EXEC [ipaddress].msdb.dbo.sp_send_dbmail

@profile_name='SQLDBA',

@recipients = 'abc@xyz.com',

@body = 'Test Mail,

@subject = 'Testing Trigger ;