SQL7Word下载.docx
《SQL7Word下载.docx》由会员分享,可在线阅读,更多相关《SQL7Word下载.docx(9页珍藏版)》请在冰点文库上搜索。
service
logon
account
was
changed
to
域\administrator
2、master数据库的迁移
进入“企业管理器”,右键点击选择服务启动,选择启动参数
原始信息如下:
-dc:
\program
files\microsoft
sql
server\MSSQ\data\master.mdf
-ec:
server\MSSQ\LOG\ERRORLOG
-lc:
server\MSSQ\data\mastlog.ldf
更改为要求迁移的路径:
-dM:
\data\master.mdf
-eM:
\LOG\ERRORLOG
-lM:
\data\mastlog.ldf
删除原始的启动参数;
重新启动SQL的服务。
3、Migrating
User
Databases
At
Query
Analyzer
DBCC
CHECKDB
Output
results
for
'
master'
.
sysobjects'
There
are
922
rows
in
14
pages
object
sysindexes'
85
3
syscolumns'
3226
41
systypes'
24
1
syscomments'
1318
499
sysfiles1'
2
syspermissions'
580
sysusers'
13
sysdepends'
3660
18
sysreferences'
0
sysfulltextcatalogs'
sysdatabases'
7
sysxlogins'
4
sysdevices'
8
sysmessages'
2997
122
sysconfigures'
43
sysservers'
syslanguages'
syscharsets'
105
30
sysaltfiles'
sysfilegroups'
sysallocations'
spt_committab'
spt_monitor'
spt_values'
675
5
spt_fallback_db'
spt_fallback_dev'
spt_provider_types'
23
spt_fallback_usg'
MSreplication_options'
spt_datatype_info_ext'
10
spt_datatype_info'
33
spt_server_info'
29
CHECKDB
found
allocation
errors
and
consistency
database
execution
completed.
If
printed
error
messages,
contact
your
system
administrator.
EXEC
sp_detach_db
YGCWDB'
pubs'
Changed
language
setting
us_english.
Successfully
detached
dbcc
traceon
(1807)
GO
sp_attach_db
'
\\192.168.0.10\home\sql70\Data\pubs.mdf'
\\192.168.0.10\home\sql70\Data\pubs_log.ldf'
traceoff
attached
Northwind'
\\192.168.0.10\home\sql70\Data\northwnd.mdf'
\\192.168.0.10\home\sql70\Data\northwnd.ldf'
\\192.168.0.10\home\sql70\Cwsj\YGCWDBLog_7.dat'
\\192.168.0.10\home\sql70\Cwsj\YGCWDBData_7.dat'
4、Restarted
Service
5、Database
Check
in