Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
DECLARE @Filename varchar(256) DECLARE @BkpPath varchar(256) DECLARE @DBName varchar(256) SET @BkpPath = 'E:\SQL Backups\TEST\' SELECT @DBName = 'MyDatabase' SELECT @FileName = @DBName + 'Backup.BAK' --SELECT @BkpPath = 'E:\SQL Backups\TEST\' SELECT @FileName = @BkpPath + @FileName DECLARE @SQL varchar(max) SELECT @SQL = 'BACKUP DATABASE ' + @DBName + ' TO DISK ='+ @FileName WITH NOFORMAT, INIT,SKIP, NOREWIND, NOUNLOAD, STATS = 10' EXEC (@SQL)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Upgrading SQL 2005 Express to 2008 R2 Express||31||203|
|SQL query to summarize items per month||5||85|
|Downgrading MS SQL 2008 R2 Enterprise to MS SQL 2005 Standard?||12||95|
Join the community of 500,000 technology professionals and ask your questions.