Notice (8): file_put_contents(): Write of 274 bytes failed with errno=28 No space left on device [CORE/src/Log/Engine/FileLog.php, line 140]

Notice: file_put_contents() [function.file-put-contents]: Write of 1108 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Notice (8): unserialize() [<a href='https://secure.php.net/function.unserialize'>function.unserialize</a>]: Error at offset 16363 of 16373 bytes [APP/Controller/NewsController.php, line 5571]

Notice: file_put_contents() [function.file-put-contents]: Write of 2761 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Undefined array key "nsort" [APP/Controller/NewsController.php, line 3613]

Notice: file_put_contents() [function.file-put-contents]: Write of 2075 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Trying to access array offset on value of type null [APP/Controller/NewsController.php, line 3613]

Notice: file_put_contents() [function.file-put-contents]: Write of 2099 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Undefined array key "nsort" [APP/Controller/NewsController.php, line 3613]

Notice: file_put_contents() [function.file-put-contents]: Write of 2075 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Trying to access array offset on value of type null [APP/Controller/NewsController.php, line 3613]

Notice: file_put_contents() [function.file-put-contents]: Write of 2099 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
SQLServer中网络备份一例 - 站长搜索
首页 > 资讯列表 > 编程/数据库 >>

SQLServer中网络备份一例

Warning (2): Undefined array key "nsort" [ROOT/plugins/Kuhuang/templates/Websites/view.php, line 430]
Notice: file_put_contents() [function.file-put-contents]: Write of 2423 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Trying to access array offset on value of type null [ROOT/plugins/Kuhuang/templates/Websites/view.php, line 430]

Notice: file_put_contents() [function.file-put-contents]: Write of 2447 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
">
Warning (2): Undefined array key "nsort" [ROOT/plugins/Kuhuang/templates/Websites/view.php, line 430]

Notice: file_put_contents() [function.file-put-contents]: Write of 2423 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Trying to access array offset on value of type null [ROOT/plugins/Kuhuang/templates/Websites/view.php, line 430]

Notice: file_put_contents() [function.file-put-contents]: Write of 2447 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
2022-09-23 17:17:03 转载来源: 网络整理/侵权必删

复制代码代码如下:use master declare @dir varchar(256),@dir_db varchar(256),         @verb varchar(256),@cmd varchar(256),         @backup_name varchar(256),@dynamic_name varchar(10),         @disk_name varchar(256) --建立网络连接 exec xp_cmdshell 'net use K: /delete' exec xp_cmdshell

复制代码 代码如下:
use master 

declare @dir varchar(256),@dir_db varchar(256), 
        @verb varchar(256),@cmd varchar(256), 
        @backup_name varchar(256),@dynamic_name varchar(10), 
        @disk_name varchar(256) 

--建立网络连接 
exec xp_cmdshell 'net use K: /delete' 
exec xp_cmdshell 'net use K: Lantbackup backup /user:Lantbackup ' 


--设定名字 
set @dynamic_name=convert(varchar(10),getdate(),120) 

set @dir='K:'+@dynamic_name 
set @dir_db=@dir+'ibm' 
set @verb='mkdir ' 


--建立目录 

--set @cmd=@verb+@dir 
--exec xp_cmdshell @cmd 

set @cmd=@verb+@dir_db 
exec xp_cmdshell @cmd 

--wap ec_wap 
set @backup_name= 'lifengOA_'+@dynamic_name 
set @disk_name=@dir_db+''+@backup_name 

EXEC sp_addumpdevice 'disk',@backup_name, @disk_name  
BACKUP DATABASE ec_wap TO @backup_name 
exec sp_dropdevice @backup_name 

--文档 ec_tech 
set @backup_name= '文档_'+@dynamic_name 
set @disk_name=@dir_db+''+@backup_name 


EXEC sp_addumpdevice 'disk',@backup_name,@disk_name  
BACKUP DATABASE ec_tech TO @backup_name 
exec sp_dropdevice @backup_name 


--博吧 ec_blog 
set @backup_name= '博吧_'+@dynamic_name 
set @disk_name=@dir_db+''+@backup_name 

EXEC sp_addumpdevice 'disk',@backup_name,@disk_name  
BACKUP DATABASE ec_blog TO @backup_name 
exec sp_dropdevice @backup_name 

exec xp_cmdshell 'net use K: /delete' 



然后做一个Task,那么,SQL Server就会备份到指定的网络地址Lantbakcup下

标签: SQLServer 网络 备份 一例


声明:本文内容来源自网络,文字、图片等素材版权属于原作者,平台转载素材出于传递更多信息,文章内容仅供参考与学习,切勿作为商业目的使用。如果侵害了您的合法权益,请您及时与我们联系,我们会在第一时间进行处理!我们尊重版权,也致力于保护版权,站搜网感谢您的分享!

站长搜索

http://www.adminso.com

Copyright @ 2007~2025 All Rights Reserved.

Powered By 站长搜索

打开手机扫描上面的二维码打开手机版


使用手机软件扫描微信二维码

关注我们可获取更多热点资讯

站长搜索目录系统技术支持