Hi Mallesh,

Please check this..

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/03/31/setting-up-database-mirroring-in-sql-server-2008-using-t-sql-when-the-database-is-encrypted-using-transparent-data-encryption.aspx

...

There is only 1 tempdb per instance and all the Dbs use it.

However you can create multiple secondary data files for the tempdb and place them on a dedicated Tempdb...

This looks like a permission issue.

Check whether the SQL Server Agent account has permissions to access this folder or if the job is running under a proxy account , does...

Temp DB cannot be shrunk as long as it is in use. Sql server can use it for the internal operations or for row versioning or for storing the user...

What does the SSIS package do?

Thank You,

Best Regards,

SQLBuddy

Yes SP3 for SQL Server 2005 went wrong for us. If your sp3 install doesn't go well there is no way back. You can't unistall SP3. It gets integrated into...

Check this

http://www.mssqltips.com/tip.asp?tip=1960

Thank You,

Best Regards,

SQLBuddy

It dosen't seem to be a permission issue. Check whether the Path you provided for the move is correct.

Also you can try to do the restore using SSMS GUI option.

Also...

If those tables are fixed and if those users are fixed with their permissions do that table creation and assign those required permisiions to those users in the Model DB...

Steve is right. You need to use logical name without the .mdf and .ldf extension within the MOVE clause.

...

Hi Shriji,

Use multiple filegroups for the VLDB. Leave the Primary File group for the system tables and create additional...

Stored procedure to do what ..

Thank You,

Best Regards,

SQLBuddy

Hi Tara,

Just do that in Model DB and those changes get reflected in al the...

Enable \PAE switch. Having 16GB on the box doesn't mean that all of that memory should be in use. It all depends on the activity on the box.

Also to make...

Steve is right there. Follow his guidelines.

Also you need to know that you should shrink the log file only for the first time since it has grown to a huge...