Activity overview
Latest activity by sskaar
Thanks Peter! I talked with our IT person and they changed the login.
Have a great day!
Sandy / comments
Thanks Peter! I talked with our IT person and they changed the login.
Have a great day!
Sandy
Edited by Moderators to Remove Account Credentials
This is one of the variable values produced by the cursor:
-SQL "BACKUP DATABASE [BLENDER] TO DISK = '\\monstor\backups\engsql02\BLENDER20080213085545.sqb'
WITH ERASEFILES_ATSTART = 2,
COMPRESSION = 1"
-U sa
-P <snipped>
Thanks!
Sandy / comments
Edited by Moderators to Remove Account Credentials
This is one of the variable values produced by the cursor:
-SQL "BACKUP DATABASE [BLENDER] TO DISK = '\\monstor\backups\engsql02\BLENDER2008021308...
Edited by Moderators to Remove Account Credentials
This is one of the variable values produced by the cursor:
-SQL "BACKUP DATABASE [BLENDER] TO DISK = '\\monstor\backups\engsql02BLENDER20080213085401.sqb'
WITH ERASEFILES_ATSTART = 2,
COMPRESSION = 1"
-U sa
-P <snipped>
Thanks!
Sandy / comments
Edited by Moderators to Remove Account Credentials
This is one of the variable values produced by the cursor:
-SQL "BACKUP DATABASE [BLENDER] TO DISK = '\\monstor\backups\engsql02BLENDER20080213085...
Edited by Moderators to Remove Account Credentials
Hi Peter,
Thanks for your reply, yes, that was a typo (sorry about that)
Here's what I have now, which is working - however, when I change the folder to the network file it fails..the file path I need to save to is:
\\monstor\backups\engsql02\'+@dbname+@filename+'''
here is my code that works today:
DECLARE @filename varchar(255)
DECLARE @dbname varchar(255)
DECLARE @sql varchar(2000)
DECLARE @exitcode int
DECLARE @sqlerrorcode int
DECLARE databases CURSOR FOR
SELECT [name]
FROM master.dbo.sysdatabases
WHERE
status != 536 and --offline
dbid != 2 --tempdb
ORDER BY
[name]
OPEN databases
FETCH NEXT FROM databases INTO @dbname @fetch_status = 0
BEGIN
SET @filename = replace(replace(replace(convert(varchar,getdate(),120) + '.sqb','-',''),':',''),' ','')
SET @sql =
'-SQL "BACKUP DATABASE TO DISK = ''d:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\'+@dbname+@filename+'''
WITH ERASEFILES_ATSTART = 2,
COMPRESSION = 1"
-U sa
-P <snipped>'
EXEC master.dbo.sqlbackup @sql
FETCH NEXT FROM databases INTO @dbname
END
CLOSE databases
DEALLOCATE databases / comments
Edited by Moderators to Remove Account Credentials
Hi Peter,
Thanks for your reply, yes, that was a typo (sorry about that)
Here's what I have now, which is working - however, when I change the fol...
T-SQL script to launch sqlbackup 5.2
Good Afternoon,
I just upgraded to sqlbackup 5.2 and now my old extended stored proc is not working. I get an error of:
Error 505: No valid SQL Backup file names entered.
Could someone please advis...