Click here to Skip to main content
       

C / C++ / MFC

 
QuestionMemory usage Pinmemberjohn563215-Nov-12 21:48 
AnswerRe: Memory usage PinmemberOrjan Westin15-Nov-12 23:23 
AnswerRe: Memory usage PinmemberDavidCrow16-Nov-12 2:27 
AnswerRe: Memory usage PinmemberRolf Kristensen16-Nov-12 3:30 
AnswerRe: Memory usage PinmemberArun S J18-Nov-12 18:13 
Questioninterp project in 64bit system PinmemberDang Vu Tuan15-Nov-12 21:46 
AnswerRe: interp project in 64bit system PinmvpRichard MacCutchan15-Nov-12 23:57 
QuestionSql server Database BackUp Pinmembershibashish mohanty15-Nov-12 20:06 
I want to take backup of my server database into my local system.so i have used the following sql query
 
DECLARE @name VARCHAR(50) -- database name
DECLARE @path VARCHAR(256) -- path for backup files
DECLARE @fileName VARCHAR(256) -- filename for backup
DECLARE @fileDate VARCHAR(20) -- used for file name
 

-- specify database backup directory
SET @path = 'C:\Backup\'
 

-- specify filename format
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)
 

DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
WHERE name IN ('Sutra') -- exclude these databases
 

OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @name
 

WHILE @@FETCH_STATUS = 0
BEGIN
SET @fileName = @path + @name + '_' + @fileDate + '.BAK'
BACKUP DATABASE @name TO DISK = @fileName
 

FETCH NEXT FROM db_cursor INTO @name
END
 

CLOSE db_cursor
DEALLOCATE db_cursor
 
i have created the Backup folder in C: drive.but it returns the following error
 
Msg 3201, Level 16, State 1, Line 28
Cannot open backup device 'C:\Backup\Sutra_20121116.BAK'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 28
BACKUP DATABASE is terminating abnormally.
 
Please solve it.Thanks in advance
shibashish mohanty

AnswerRe: Sql server Database BackUp PinmvpRichard MacCutchan15-Nov-12 23:55 
AnswerRe: Sql server Database BackUp PinmemberAndré Kraak16-Nov-12 0:48 
QuestionNeed help compiling PinmemberxLeonx15-Nov-12 8:51 
AnswerRe: Need help compiling Pinmemberjeron115-Nov-12 9:51 
QuestionRe: Need help compiling PinmemberDavidCrow15-Nov-12 10:34 
QuestionRe: Need help compiling PinmvpCPallini15-Nov-12 23:09 
AnswerRe: Need help compiling PinmemberxLeonx18-Nov-12 9:35 
AnswerRe: Need help compiling PinmemberStephen Hewitt16-Nov-12 22:36 
GeneralRe: Need help compiling PinmemberxLeonx18-Nov-12 9:31 
GeneralRe: Need help compiling PinmemberxLeonx18-Nov-12 9:33 
AnswerRe: Need help compiling PinmemberArun S J18-Nov-12 18:15 
GeneralRe: Need help compiling PinmemberxLeonx23-Nov-12 8:20 
GeneralRe: Need help compiling PinmemberArun S J25-Nov-12 17:37 
QuestionVisual Studio 2003 on Windows 8! PinmemberHadi Dayvary15-Nov-12 4:23 
Question[RESOLVED] Message Box will not show on top of window PinmemberBrandon T. H.15-Nov-12 1:14 
AnswerRe: Message Box will not show on top of window PinmvpRichard MacCutchan15-Nov-12 3:16 
GeneralRe: Message Box will not show on top of window PinmemberBrandon T. H.15-Nov-12 8:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 20 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid