sql server back up database

sql server  还原一个数据到具体的时间

 

---

 

数据库的附加:

sp_attach_db mark ,'C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Data/mark.mdf'
数据库的分离:

sp_deattach_db mark ,'C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Data/mark.mdf'

数据库的完全备份:

backup database mark to disk='D:/Database/mark.bat'

数据库的加密备份:

backup database mark to disk='D:/Database/mark.bat' with password 'password'

数据库的差异备份:

backup database mark to disk='D:/Database/mark.bat' with Diffreential

 

---

 

数据库文件备份:

backup database mark file='Filepath' to 'backupfile path'

数据库文件组备份

backup database mark filegroup='filegroup path' to 'back filegroup path '

 

---

 

数据库日志备份:

backup log  databasenaem to disk='backup file path'

 

数据库的还原:

数据库的完全还原:

restore database mark  from disk='Database/mark.bat'

数据库的差异备份

alter database mark set recovery full
go
backup database mark to disk ='D:/Database/mark.bat'
go
restore database mark from disk='D:/Database/mark.bat' with recovery,replace,STOPAT='2010-04-19 16:10:40.100'

 

---

 

数据库添加一个备份设备

exec sp_addumpdevice 'disk','新备份设备' ,'back up file path'