/*
Script will  Create a Backup Script for utilization with Server Moves
Create by David Johnson 02/20/14
Run the results against your database.

*/
Declare @BLocation as varchar(80) --Backup Location
declare @SQL as varchar(1000)
declare @STR as varchar(80)
declare @str2 as varchar(80)

declare @qt as varchar(1)
declare @COID as varchar(10)



select @BLocation ='D:\Server_Move022014\'
select @qt = char(39)





DECLARE BACKUP_Cursor CURSOR FOR
SELECT 'DYNAMICS'
union all
SELECT INTERID FROM DYNAMICS..SY01500 
--where INTERID not in ('A060', 'A002') -- Add databases you don't want data for
--order by INTERID

OPEN BACKUP_Cursor
FETCH NEXT FROM BACKUP_Cursor
INTO @COID

WHILE @@FETCH_STATUS = 0 
BEGIN

Print '-------------------------------------------------'
print '--Backing up ' + @COID
Print ''

select @SQL =  'backup database ' + rtrim(@COID) +' TO Disk = ' + @qt + @BLocation + rtrim(@COID) + '.bak' + @qt
print @SQL
print 'WITH INIT, COMPRESSION'

Print '-------------------------------------------------'
Print ''
Print ''
	
FETCH NEXT FROM BACKUP_Cursor
INTO @COID

END
CLOSE BACKUP_Cursor
DEALLOCATE BACKUP_Cursor