|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 1st, 2005, 04:47 PM
|
|||
|
|||
|
backup file name
I'm running this backup script but it is stripping the backup file name. Any ideas, why? It was working correctly before we change our naming convention for the databases and move the test databases to a new Test DB Svr.
I think it has something to do with the new path location. Code:
DECLARE @DBName NVARCHAR(100), @Device NVARCHAR(100), @Name NVARCHAR(150) DECLARE cur_DBs CURSOR STATIC LOCAL FOR SELECT Catalog_Name
FROM Information_Schema.Schemata
WHERE [Catalog_Name]
NOT IN ('MASTER',
'MODEL',
'MSDB',
'TEMPDB')
OPEN cur_DBs
FETCH NEXT
FROM cur_DBs
INTO @DBName WHILE @@FETCH_STATUS = 0 BEGIN
SET @Device = N'\\DestinyDev\c$\Program Files\Microsoft SQL Server\MSSQL\BACKUP\DATA\' + @DBName + '_Diff_' + LEFT(REPLACE(REPLACE(REPLACE(CONVERT(NVARCHAR(30),
GETDATE(), 120), '-', ''), ':', ''), ' ', ''), 12) + N'.BAK'
SET @Name = @DBName + N' Diff Backup' PRINT 'Backing up database ' + @DBName BACKUP DATABASE @DBName TO DISK = @Device WITH DIFFERENTIAL,
NOUNLOAD, NAME = @Name, NOSKIP, STATS = 10, NOFORMAT RESTORE VERIFYONLY
FROM DISK = @Device WITH FILE = 1 PRINT '--------------------------------------- ' FETCH NEXT
FROM cur_DBs
INTO @DBName END CLOSE cur_DBs DEALLOCATE cur_DBs
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > backup file name |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
