November 26, 2011 at 11:29 am
how to copy backup file sqlserver query
November 26, 2011 at 11:30 am
you can try it with xp_cmdshell
November 26, 2011 at 11:32 am
can u provide the full sqlquery
November 26, 2011 at 11:34 am
EXEC xp_cmdshell 'copy c:\sqldumps\pubs.dmp \\server2\backups\sqldumps',
NO_OUTPUT
http://msdn.microsoft.com/en-us/library/aa260689(v=sql.80).aspx
November 28, 2011 at 3:35 am
Use of xp_cmdshell could be very risky. Please don't forget to read following before you decide on it.
I cringe every time I see a recommendation for xp_cmdshell.
November 29, 2011 at 7:56 pm
BACKUP DATABASE [AdventureWorks] TO
DISK = N'\as\Backup\L40\SQL2005\AdventureWorks_backup_200702120215.bak'
WITH NOFORMAT, NOINIT, NAME = N'AdventureWorks-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply