Database Support FAQ

After restoring a copy of a database my SQL logfiles grow very large, very fast. After a while the harddrive is full. What is wrong?

The problem might have to do with Orphaned User in the restored database. Check if the log file indicates something about Orphaned Users. You can read more about the problem here

http://www.sql-server-performance.com/2008/fixing-orphaned-users-in-sql-server-database/3/

I am trying to restore a backup from a different server on a new server but I get an error "System.Data.SqlClient.SqlError: The operating system returned the error '3' (The system cannot find the path specified.)' while attempting 'CreateFile' on 'C:\Prog

First, make sure that if the backup was made on a server with fulltext search switched on, the target server must also have fulltext search switched on. Furthermore, check that the user SQLSERVER2005MSSQLUSER$<yourusername>$SQLEXPRESS has write access in the MSSQL directory.

I am using Vista/Windows 7 and have installed Aligned Elements but I cannot create offline databases. Why?

Due to windows security restrictions in Windows 7 Aligned Elements cannot create the necessary folders for the offline databases. Try to manually create the path "C:/AlignedElements/Offline" and try again.

When I open the project I get the following message: "InitSubscription failed. Exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

Open SQL Server Studio Manager and post the following two queries:

ALTER DATABASE "<the database name>" SET NEW_BROKER WITH ROLLBACK IMMEDIATE;

and then

ALTER DATABASE "<the database name>" SET ENABLE_BROKER;

When I restore a database I get the following message:"The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported." What should I do?

Open SQL Server Studio Manager and post the following two queries:

ALTER DATABASE "<the database name>" SET NEW_BROKER WITH ROLLBACK IMMEDIATE;

and then

ALTER DATABASE "<the database name>" SET ENABLE_BROKER;