| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 502 人关注过本帖
标题:[求助]SQL备份语句出错拉!!
只看楼主 加入收藏
shuzhenqiu
Rank: 1
等 级:新手上路
帖 子:48
专家分:0
注 册:2005-12-9
收藏
 问题点数:0 回复次数:4 
[求助]SQL备份语句出错拉!!
"backup database 小区物业管理系统 to disk '本地磁盘' with init, name='beifei'";
我要备份数据库,这句话错拉啊,
大家帮我找找错误啊!!
谢谢!!!
搜索更多相关主题的帖子: SQL 语句 
2006-04-07 22:12
LouisXIV
Rank: 6Rank: 6
等 级:贵宾
威 望:25
帖 子:789
专家分:0
注 册:2006-1-5
收藏
得分:0 
英文版联机丛书上是这样写的
A. Back up the entire MyNwind database

Note The MyNwind database is shown for illustration only.

This example creates a logical backup device in which a full backup of the MyNwind database is placed.

-- Create a logical backup device for the full MyNwind backup.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_1', 
   DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'

-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_1
B. Back up the database and log

This example creates both a full database and log backup. The database is backed up to a logical backup device called MyNwind_2, and then the log is backed up to a logical backup device called MyNwindLog1.

Note Creating a logical backup device needs to be done only once.

-- Create the backup device for the full MyNwind backup.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_2',
   'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_2.dat'

--Create the log backup device.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwindLog1',
   'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwindLog1.dat'

-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_2

-- Update activity has occurred since the full database backup.

-- Back up the log of the MyNwind database.
BACKUP LOG MyNwind 
   TO MyNwindLog1

2006-04-07 22:26
shuzhenqiu
Rank: 1
等 级:新手上路
帖 子:48
专家分:0
注 册:2005-12-9
收藏
得分:0 
看不懂哦,你解释解释哦,谢谢拉
2006-04-07 22:33
cfg1014
Rank: 1
等 级:新手上路
帖 子:42
专家分:0
注 册:2006-1-7
收藏
得分:0 
backup database 小区物业管理系统 to disk='本地磁盘\beifei.dat'

2006-04-08 09:35
shuzhenqiu
Rank: 1
等 级:新手上路
帖 子:48
专家分:0
注 册:2005-12-9
收藏
得分:0 

谢谢。拉
解决拉

2006-04-08 12:33
快速回复:[求助]SQL备份语句出错拉!!
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.018994 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved