SQL Server - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÎÒSQLÖØ×°×°ºÃÁË µ«ÊÇ»¹ÓиöÎÊÌâ ÎÒ֮ǰÓùýµÄÊý¾Ý¿âÃû²»ÄÜÔÙÓÃÁË ÕâÊǸö´óÎÊÌâ Çó¸ßÊÖ°ïæ

---

ÎÞͼÎÞÕæÏà

---

ÊDz»ÊÇÔÚwindows·þÎñÀﻹûɾ³ý

---

֮ǰÓùýµÄÊý¾Ý¿âÓб¸·Ýô£¿£¿

---

ÒýÓÃ

ÎÞͼÎÞÕæÏà

ÎÞͼÎÞÕæÏà

---

Ö±½Ó°ÑMDFºÍLDFÄóöÀ´¸½¼Ó

---

лл´ó¼Ò µ«ÊÇÎÒ˵µÄÄǸöÎÊÌâÒÀÈ»´æÔÚ Ö®Ç°¹ÖÎÒûÓн²Çå³þ
 ÊÇÕâÑùµÄ£º¾ÉµÄÊý¾Ý¿âÎļþ£¨mdfºÍÈÕÖ¾Îļþ£©ÎÒɾµôÁË µ«»¹ÊDz»ÄÜÖؽ¨ÖØÃûÊý¾Ý¿â ¸½¼ÓÀïûÓÐÊý¾Ý¿â

---

ÏÖÔÚ ÎÒÏë Á˽âÊý¾Ý¿âÊÇÈçºÎ×¢²áµÄ ÄÄλ¸ßÊÖÍƼö±¾Ê飨¾ßÌåÊéÃû µç×Ó°æµÄÒ²ÐУ©

  ÔÚ´Ë Ð»Ð»ÖîλÏÈ£¡£¡£¡

---

±êÌâ: Microsoft SQL Server Management Studio
------------------------------

´´½¨ ¶ÔÓÚ Êý¾Ý¿â¡°niit¡±Ê§°Ü¡£ (Microsoft.SqlServer.Smo)
------------------------------
ÆäËûÐÅÏ¢:

Ö´ÐÐ Transact-SQL Óï¾ä»òÅú´¦Àíʱ·¢ÉúÁËÒì³£¡£ (Microsoft.SqlServer.ConnectionInfo)

------------------------------

ÎÞ·¨´´½¨Îļþ 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\niit_log.ldf'£¬ÒòΪËüÒÑ´æÔÚ¡£Çë¸ü¸ÄÎļþ·¾¶»òÎļþÃû£¬È»ºóÖØÊԴ˲Ù×÷¡£
CREATE DATABASE ʧ°Ü¡£ÎÞ·¨´´½¨ÁгöµÄijЩÎļþÃû¡£Çë²é¿´Ïà¹Ø´íÎó¡£ (Microsoft SQL Server£¬´íÎó: 5170)

---

The database log files for NIIT already exist in (the error msg already says:'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\niit_log.ldf' exists). Simply delete it and you will be albe to recreate that data