Click here to Skip to main content
15,885,216 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
QuestionMemory usage Pin
john563215-Nov-12 21:48
john563215-Nov-12 21:48 
AnswerRe: Memory usage Pin
Orjan Westin15-Nov-12 23:23
professionalOrjan Westin15-Nov-12 23:23 
AnswerRe: Memory usage Pin
David Crow16-Nov-12 2:27
David Crow16-Nov-12 2:27 
AnswerRe: Memory usage Pin
Rolf Kristensen16-Nov-12 3:30
Rolf Kristensen16-Nov-12 3:30 
AnswerRe: Memory usage Pin
Arun S J18-Nov-12 18:13
Arun S J18-Nov-12 18:13 
Questioninterp project in 64bit system Pin
Dang Vu Tuan15-Nov-12 21:46
Dang Vu Tuan15-Nov-12 21:46 
AnswerRe: interp project in 64bit system Pin
Richard MacCutchan15-Nov-12 23:57
mveRichard MacCutchan15-Nov-12 23:57 
QuestionSql server Database BackUp Pin
shibashish mohanty15-Nov-12 20:06
shibashish 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
mveRichard MacCutchan15-Nov-12 23:55 
AnswerRe: Sql server Database BackUp Pin
André Kraak16-Nov-12 0:48
André Kraak16-Nov-12 0:48 
QuestionNeed help compiling Pin
xLeonx15-Nov-12 8:51
xLeonx15-Nov-12 8:51 
AnswerRe: Need help compiling Pin
jeron115-Nov-12 9:51
jeron115-Nov-12 9:51 
QuestionRe: Need help compiling Pin
David Crow15-Nov-12 10:34
David Crow15-Nov-12 10:34 
QuestionRe: Need help compiling Pin
CPallini15-Nov-12 23:09
mveCPallini15-Nov-12 23:09 
AnswerRe: Need help compiling Pin
xLeonx18-Nov-12 9:35
xLeonx18-Nov-12 9:35 
AnswerRe: Need help compiling Pin
Stephen Hewitt16-Nov-12 22:36
Stephen Hewitt16-Nov-12 22:36 
GeneralRe: Need help compiling Pin
xLeonx18-Nov-12 9:31
xLeonx18-Nov-12 9:31 
GeneralRe: Need help compiling Pin
xLeonx18-Nov-12 9:33
xLeonx18-Nov-12 9:33 
AnswerRe: Need help compiling Pin
Arun S J18-Nov-12 18:15
Arun S J18-Nov-12 18:15 
GeneralRe: Need help compiling Pin
xLeonx23-Nov-12 8:20
xLeonx23-Nov-12 8:20 
GeneralRe: Need help compiling Pin
Arun S J25-Nov-12 17:37
Arun S J25-Nov-12 17:37 
QuestionVisual Studio 2003 on Windows 8! Pin
Hadi Dayvary15-Nov-12 4:23
professionalHadi Dayvary15-Nov-12 4:23 
Question[RESOLVED] Message Box will not show on top of window Pin
Brandon-X1200015-Nov-12 1:14
Brandon-X1200015-Nov-12 1:14 
AnswerRe: Message Box will not show on top of window Pin
Richard MacCutchan15-Nov-12 3:16
mveRichard MacCutchan15-Nov-12 3:16 
GeneralRe: Message Box will not show on top of window Pin
Brandon-X1200015-Nov-12 8:13
Brandon-X1200015-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.