[edit]
16 蠍壱 襷 襭 #
![[http]](/moniwiki/imgs/http.png)
SQL Server襯 ろ 覯 伎 一危磯伎るゼ 企 蟠 覓語襯 願屋 覦覯(http://support.microsoft.com/kb/240872/)
- MS る覃讌 蟆(http://support.microsoft.com/gp/errormessage)
- Windows 覯 ろ 觜 螳 覦 ろ語 蟲 (http://support.microsoft.com/kb/832017)
磯碁_session朱_誤_覿レ.pdf
豌 襯 給. 豢螳 覲: 豌 襯 給. (SqlMgmt) Transact SQL 覓 手 豌襴襯 ろ 瑚 覦 給. (Microsoft.SqlServer.ConnectionInfo) 螳 蟠 給. (Microsoft SQL Server, る: 297)
select A.c1, A.c2, B.cc2 from [c:\db1.mdb].Table1 A, [c:\db2.mdb].Table1 B where A.c1 = B.c1
1. sp_dropserver 'Old_Server_Name'
2. sp_addserver 'New_Server_Name',local
3. 觜 ろ
select @@servername, serverproperty('servername')
-- 貉殊 螳 螳
File C:\connect.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see "get-help about_signing" for more details. At line:1 char:9 + ./connect <<<< 企一 覃語襯 覦 蟆曙?? 螳 覃 ... get-executionpolicy set-executionpolicy unrestricted get-executionpolicy
/* 覓語
Microsort SQL-DMO (ODBC SQLState: HY000), Expression: fcb->GetSize ()< fileSize
る 3624
Location: filemgr.cpp:1890
Expression: fcb->GetSize ()< fileSize
SPID: 52
Process ID: 1168
: れ 狩蠍一 MDF殊 蠍磯 狩蠍郁 殊 ..
:
1. dbcc rebuild_log sp_resetstatusろ 觜 覃 覲糾規..覲糾規 ろ..
2. 覈 (dbcc dbrecovery )
*/
sp_configure 'allow updates', 1
reconfigure with override
go
update sysdatabases
set status = 32768
where dbid = DB_ID('<db_name>')
go
sp_configure 'allow updates', 0
reconfigure with override
go
dbcc rebuild_log('<db_name>', '<drive_path like c:\database\sid\log\lodfile1.ldf')
go
dbcc checkdb('<db_name>')
go
sp_dboption '<db_name>', 'dbo use only', 'false'
go
dbcc dbrecover('<db_name>')
go
exec sp_resetstatus ('<db_name>')
go
dbcc checkdb('<db_name>',<FoundRepairClause>)
go
--Suspect!!
USE master
GO
EXEC sp_configure 'allow updates', 1
RECONFIGURE WITH OVERRIDE
GO
UPDATE master..sysdatabases SET status = 32768
WHERE name = 'act'
GO
UPDATE master..sysdatabases SET status = 32768
WHERE name = 'etc'
GO
UPDATE master..sysdatabases SET status = 32768
WHERE name = 'mat'
GO
UPDATE master..sysdatabases SET status = 32768
WHERE name = 'pay'
GO
UPDATE master..sysdatabases SET status = 32768
WHERE name = 'sal'
GO
USE master
GO
DBCC REBUILD_LOG('act','E:\PKFC\act\act_log.LDF')
GO
DBCC REBUILD_LOG('etc','E:\PKFC\etc\etc_log.LDF')
GO
DBCC REBUILD_LOG('mat','E:\PKFC\mat\mat_log.LDF')
GO
DBCC REBUILD_LOG('pay','E:\PKFC\pay\pay_log.LDF')
GO
DBCC REBUILD_LOG('sal','E:\PKFC\sal\sal_log.LDF')
GO
exec sp_resetstatus 'act'
GO
exec sp_resetstatus 'etc'
GO
exec sp_resetstatus 'mat'
GO
exec sp_resetstatus 'pay'
GO
exec sp_resetstatus 'sal'
GO
EXEC sp_configure 'allow updates', 0
RECONFIGURE WITH OVERRIDE
GO
DBCC CHECKDB('act')
GO
DBCC CHECKDB('etc')
GO
DBCC CHECKDB('mat')
GO
DBCC CHECKDB('pay')
GO
DBCC CHECKDB('sal')
GO
1) SQLDMO 覦 蟯 fileれ unregistry れ CD replace registry 焔. step0. SQL Server襯 譬襭. step1. SQLDMO.dll 豺襯 誤 unregister . => cmd 谿曙 regsvr32 /u c:\program files\microsoft sql server\80\tools\binn\sqldmo.dll . step2. 蠍一ヾ SQLSMO.dll rename 螻 SQL れ CD 覲旧 replace . step3. cmd 谿曙 regsvr32 c:\program files\microsoft sql server\80\tools\binn\sqldmo.dll EM open 炎概朱 ろ . 2) EM 讌 蟯襴 螻 伎 れ譽 覦煙 覲るジ 炎概朱 ろ . 3) SQL Server Personal Edition れ SQL Server Standard Edition朱 れ 襷. step0. 一危磯伎 手煙 誤 master User DB襯 覦煙 覦. step1. 襦蠏碁 豢螳/蟇一 SQL Server . step2. regedit SQL 蟯 启 . => HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server => HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer step3. Windows 2000 覿 SQL Server Standard Edition れ. step4. SQL Server Service 襯 覈襦 . => cmd 谿曙 net start mssqlserver /m => EM 伎 master 一危磯伎 襴ろ. => master DB User DB 覲願 User DB 覲旧 . 4) C:\inetpub\scripts 启襯 C:\襦 企 . scripts TFTP 殊 焔 蟆 誤螻 nimda virus code red 螳殊朱 豢. 启襯 朱 殊 譴企襦 蟇郁 讌 る る 覃語 覦. IIS 觜り 讌 蟆 . scripts 启 焔覲 . 启 蟠 蟇磯襦 覈 蟠 朱 覲蟆. 启 炎概.
--[MSSQL2k5]Error 0x80040155, 焔讌 誤壱伎れ regsvr32 msxml3.dll regsvr32 msxml6.dll
ALTER DATABASE database_name SET SINGLE_USER With ROLLBACK IMMEDIATE RESTORE FILELISTONLY from Disk = 'C:\database_name.bak' restore database database_name from Disk = 'C:\database_name.bak' with recovery, move 'xERP_Data' to 'D:\database_name_Data.MDF', move 'xERP_Log' to 'D:\database_name_log.LDF' ALTER DATABASE database_name SET MULTI_USER
--覦煙レ 豢螳 USE master EXEC sp_addumpdevice 'tape', 'nexen_backup','\\.\Tape0' go backup database pubs to nexen_backup -- 願 豢螳 覦煙 レ覈... go --レ覲願鍵 exec sp_helpdevice --覦煙レ 讌郁鍵 --sp_dropdevice 'nexen_backup' --企れ 危 覈襦 覲願鍵 select * from sysopentapes --螳蠍磯ゼ 覃 企れ 危螳 . RESTORE LABELONLY FROM TAPE = '\\.\tape0' WITH REWIND
--覦煙覲 覓願屋 RESTORE VERIFYONLY FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\test.bak' WITH FILE = 1 , NOUNLOAD
[MSSQL2005] 覃讌 10327, 譴 14, 1, 譴 1 豌覦覯 USE Master; ALTER DATABASE AdventureWorks SET TRUSTWORTHY ON; GRANT EXTERNAL ACCESS ASSEMBLY to [Builtin\Administrators];
SQL Server襯 ろ 覯 伎 一危磯伎るゼ 企 蟠 覓語襯 願屋 覦覯(http://support.microsoft.com/kb/240872/)MS る覃讌 蟆(http://support.microsoft.com/gp/errormessage)Windows 覯 ろ 觜 螳 覦 ろ語 蟲 (http://support.microsoft.com/kb/832017)磯碁_session朱_誤_覿レ.pdf