exec sp_addumpdevices 'disk','p1','d:\back.dat'
backup database pubs to p1
exec sp_dropdumpdevices 'p1'//用上一个back.dat移过来overwrite
exec sp_addumpdevices 'disk','p1','d:\back.dat'
restore database pubs from p1
exec sp_dropdumpdevices 'p1'
backup database pubs to p1
exec sp_dropdumpdevices 'p1'//用上一个back.dat移过来overwrite
exec sp_addumpdevices 'disk','p1','d:\back.dat'
restore database pubs from p1
exec sp_dropdumpdevices 'p1'
2、使用backup、restore;
3、使用Export & import;
4、使用bcp;
5、使用DTS;
以上5种均可实现