If you want to move...

You can try the below options:

Increase the size of 'MAX GROWTH' (If ample space is available in the drive hosting t-log)

If not, you can try this

USE MASTER

GO

DBCC FREESESSIONCACHE WITH NO_INFOMSGS

GO

DBCC...

Space in t-log is made reusable in SIMPLE recovery model as soon as the transaction is Committed/ written to the database. Have you restricted your t-log growth? If you don't...

What is the recovery Model of the database?

What is the size of t-log and growth options?

Hello,

Please refer to the below links:

http://www.techrepublic.com/blog/10things/10-tips-for-upgrading-to-sql-server-2008-r2/2376

http://msdn.microsoft.com/en-us/library/ms143699(v=sql.105).aspx

Let us know if further help is required.

Regards..

Hello Dearone,

SQL Server 2005 has grown old now (though it is still being used in production by many). The latest version of SQL Server is 2012.

I believe your question should...

Hello,

Renaming a database will include the keyword 'ALTER'.The backup schedule was unaffected by renaming of the database because the triggers you have acts on events of 'CREATE' and 'DROP' and...

When is the next edition coming???:)