Hello,

Not sure if this works for you.

My firm understanding We don't have an option to create a alias name for the database, you can create the alias for tables.

But you...

There are some common reasons why a transaction log might not shrink when you use the DBCC SHRINKFILE or DBCC SHRINKDATABASE command.

Please rerfer to the following link

I have just verified, it looks like we can set the maxzise='unlimited' can only be set to data file not to log file.

Please verify the following...

1. Check the system and sql eventviewer for timeout or any other connectivity issues.

2. Check the sufficient space avaiable for temp and user database.

3. Check to see...

It looks like logfile is not able to locate the file database_log1. use sp_helpdb master. check to see if the files are present.

Note: take the full backup for master database...

Check to see that in temporary tables got created in your temp db in case if you have used temp objects in inserts or updates.This is one such reason i...

We dont have any limitation on number of databases a SQL Server should have. We need to analyse carefully identify the offender. Is the performance is same across all the...

Its seems to be an open issue in both sql server 2000 and SQL Server 2005. We cannot shrink the database less than the initial size.