SQL Server导入数据库文件命令
step.1 将文件传入服务器
- 通过ftp
- 等等
step.2 执行命令
1
2
3
EXEC sp_attach_db @dbname= 'northwnd',
@filename1 = '/home/ftp/northwnd.mdf',
@filename2 = '/home/ftp/northwnd.ldf'
1
2
3
EXEC sp_attach_db @dbname= 'northwnd',
@filename1 = '/home/ftp/northwnd.mdf',
@filename2 = '/home/ftp/northwnd.ldf'
