当前位置: 动力学知识库 > 问答 > 编程问答 >

how to sql server backup on tsclient

问题描述:

DECLARE @name VARCHAR(50) -- database name

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @fileName VARCHAR(256) -- filename for backup

DECLARE @fileDate VARCHAR(20) -- used for file name

SET @path = '\\tsclient\d:\'

SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)

DECLARE db_cursor CURSOR FOR

SELECT name

FROM CC.master.dbo.sysdatabases

WHERE name NOT IN ('master','model','msdb','tempdb')

OPEN db_cursor

FETCH NEXT FROM db_cursor INTO @name

WHILE @@FETCH_STATUS = 0

BEGIN

SET @fileName = @path + @name + '_' + @fileDate + '.BAK'

BACKUP DATABASE @name TO DISK = @fileName

FETCH NEXT FROM db_cursor INTO @name

END

CLOSE db_cursor

DEALLOCATE db_cursor

then show error

Msg 3201, Level 16, State 1, Line 21

Cannot open backup device '\tsclient\d:\Deecoup_20131022.BAK'. Operating system error 67(The network name cannot be found.).

Msg 3013, Level 16, State 1, Line 21

BACKUP DATABASE is terminating abnormally.

分享给朋友:
您可能感兴趣的文章:
随机阅读: