Hi
How to copy backup database to Google drive from store procedure in sql sever
I have code like this
ALTER procedure [dbo].[backup_data]
as
DECLARE @SQLStatement VARCHAR(2000)
SET @SQLStatement = N'E:\BakupData\DBdata_'+ CONVERT(nvarchar(30), GETDATE(), 105) +'.bak'
BACKUP DATABASE [DBTest] TO DISK = @SQLStatement
WITH NOFORMAT, NOINIT, NAME = N'DBTest-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
problem : how to copy DDbata_.bak to google drive when store procedure backup_data running
thanks