You need to move the transaction log files for the Project Server databases to a dedicated drive

You have a Microsoft Office Project Server 2007 environment. You need to move the transaction log files for the Project Server databases to a dedicated drive. What should you do?

You have a Microsoft Office Project Server 2007 environment. You need to move the transaction log files for the Project Server databases to a dedicated drive. What should you do?

A.
Use SQL Server Management Studio to take the databases offline. In Windows Explorer, move the transaction log files to the dedicated drive. Use SQL Server Management Studio to bring the databases online.

B.
Stop the SQL Server service. In Windows Explorer, delete the transaction log files. Start the SQL Server service. Use SQL Server Management Studio to add new transaction log files and specify the dedicated drive.

C.
Use SQL Server Management Studio to add a new data file and specify the dedicated drive. Delete the existing data file.

D.
Use SQL Server Management Studio to detach the databases. In Windows Explorer, move the transaction log files to the dedicated drive. Use SQL Server Management Studio to reattach the databases and specify the new location for the log files.



Leave a Reply 0

Your email address will not be published. Required fields are marked *