Click here to Skip to main content
13,000,636 members (38,867 online)

C / C++ / MFC

 
QuestionMemory usage Pin
john563215-Nov-12 21:48
memberjohn563215-Nov-12 21:48 
AnswerRe: Memory usage Pin
Orjan Westin15-Nov-12 23:23
memberOrjan Westin15-Nov-12 23:23 
AnswerRe: Memory usage Pin
DavidCrow16-Nov-12 2:27
memberDavidCrow16-Nov-12 2:27 
AnswerRe: Memory usage Pin
Rolf Kristensen16-Nov-12 3:30
memberRolf Kristensen16-Nov-12 3:30 
AnswerRe: Memory usage Pin
Arun S J18-Nov-12 18:13
memberArun S J18-Nov-12 18:13 
Questioninterp project in 64bit system Pin
Dang Vu Tuan15-Nov-12 21:46
memberDang Vu Tuan15-Nov-12 21:46 
AnswerRe: interp project in 64bit system Pin
Richard MacCutchan15-Nov-12 23:57
mvpRichard MacCutchan15-Nov-12 23:57 
QuestionSql server Database BackUp Pin
shibashish mohanty15-Nov-12 20:06
membershibashish 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 Pin
Richard MacCutchan15-Nov-12 23:55
mvpRichard MacCutchan15-Nov-12 23:55 
AnswerRe: Sql server Database BackUp Pin
André Kraak16-Nov-12 0:48
memberAndré Kraak16-Nov-12 0:48 
QuestionNeed help compiling Pin
xLeonx15-Nov-12 8:51
memberxLeonx15-Nov-12 8:51 
AnswerRe: Need help compiling Pin
jeron115-Nov-12 9:51
memberjeron115-Nov-12 9:51 
QuestionRe: Need help compiling Pin
DavidCrow15-Nov-12 10:34
memberDavidCrow15-Nov-12 10:34 
QuestionRe: Need help compiling Pin
CPallini15-Nov-12 23:09
mvpCPallini15-Nov-12 23:09 
AnswerRe: Need help compiling Pin
xLeonx18-Nov-12 9:35
memberxLeonx18-Nov-12 9:35 
AnswerRe: Need help compiling Pin
Stephen Hewitt16-Nov-12 22:36
memberStephen Hewitt16-Nov-12 22:36 
GeneralRe: Need help compiling Pin
xLeonx18-Nov-12 9:31
memberxLeonx18-Nov-12 9:31 
GeneralRe: Need help compiling Pin
xLeonx18-Nov-12 9:33
memberxLeonx18-Nov-12 9:33 
AnswerRe: Need help compiling Pin
Arun S J18-Nov-12 18:15
memberArun S J18-Nov-12 18:15 
GeneralRe: Need help compiling Pin
xLeonx23-Nov-12 8:20
memberxLeonx23-Nov-12 8:20 
GeneralRe: Need help compiling Pin
Arun S J25-Nov-12 17:37
memberArun S J25-Nov-12 17:37 
QuestionVisual Studio 2003 on Windows 8! Pin
Hadi Dayvary15-Nov-12 4:23
memberHadi Dayvary15-Nov-12 4:23 
Question[RESOLVED] Message Box will not show on top of window Pin
Brandon T. H.15-Nov-12 1:14
memberBrandon T. H.15-Nov-12 1:14 
AnswerRe: Message Box will not show on top of window Pin
Richard MacCutchan15-Nov-12 3:16
mvpRichard MacCutchan15-Nov-12 3:16 
GeneralRe: Message Box will not show on top of window Pin
Brandon T. H.15-Nov-12 8:13
memberBrandon T. H.15-Nov-12 8:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web02 | 2.8.170624.1 | Last Updated 25 Jun 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid