![]() ![]() Therefore, when you attach a read-only database with a log that is unavailable, you must provide the log files, or the files in the FOR ATTACH clause. In contrast, for a read-only database, the log cannot be rebuilt because the primary file cannot be updated. If a read/write database has a single log file that is currently unavailable, and if the database was shut down with no users or open transactions before the attach operation, FOR ATTACH automatically rebuilds the log file and updates the primary file. If multiple log files exist, they must all be available. ![]() 2) Make sure you have Authentication: Windows Authentication (no username & password) 3) For the server name field look to the right and select the drop down arrow, click 'browse for more'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |