Click here to Skip to main content
16,006,348 members
Home / Discussions / C#
   

C#

 
GeneralRe: starting and stopping the sql server programaticaly Pin
DaveyM6914-Feb-08 22:55
professionalDaveyM6914-Feb-08 22:55 
QuestionRe: starting and stopping the sql server programaticaly Pin
Sonia Gupta14-Feb-08 22:59
Sonia Gupta14-Feb-08 22:59 
GeneralRe: starting and stopping the sql server programaticaly Pin
DaveyM6914-Feb-08 23:25
professionalDaveyM6914-Feb-08 23:25 
QuestionRe: starting and stopping the sql server programaticaly Pin
Sonia Gupta14-Feb-08 23:31
Sonia Gupta14-Feb-08 23:31 
AnswerRe: starting and stopping the sql server programaticaly Pin
Martin#14-Feb-08 23:44
Martin#14-Feb-08 23:44 
GeneralRe: starting and stopping the sql server programaticaly Pin
Sonia Gupta14-Feb-08 23:56
Sonia Gupta14-Feb-08 23:56 
GeneralRe: starting and stopping the sql server programaticaly Pin
Martin#14-Feb-08 23:59
Martin#14-Feb-08 23:59 
GeneralRe: starting and stopping the sql server programaticaly Pin
Mike Dimmick15-Feb-08 0:38
Mike Dimmick15-Feb-08 0:38 
Sonia Gupta wrote:
Reason is , i have to take the backup of the database , at regular intervals.


You should be using SQL Server's built-in backup facilities rather than trying to back up the data and log files as files. Use SQL Agent to schedule backups of the database and (if applicable) transaction logs.

Many backup products (e.g. Backup Exec) include support for backing up SQL Server through SQL Server's backup API.

If you're running SQL Server 2005 on Windows Server 2003, backups of the files through Volume Shadow Copy services are possible. However, you should prefer to use SQL Server's own backup facilities where possible.

If you want to perform a backup under programmatic control, rather than scheduling a job, you can use the BACKUP DATABASE command.

If you don't fully understand the transaction log, you should set the database to use the Simple recovery model. This will allow you only to restore the last full backup - any operations performed after the backup was started will be lost. If you leave it using the Full or Bulk-Logged recovery models, after performing a full backup through the SQL Server API, the transaction log will retain records of all operations performed in order to allow recovery to the point of failure.

These records are only cleared when the transaction log is backed up through SQL Server's backup API or the BACKUP LOG command. The log is not cleared after performing a full backup. Typically this means that the log file will keep growing, depending on the log growth configuration. If the log cannot grow any more due to hitting the limit configured, having autogrow disabled, or running out of disk space, the server will fail the operation.


DoEvents: Generating unexpected recursion since 1991

QuestionHow to draw line on stretched image in picturebox control Pin
swapck14-Feb-08 19:23
swapck14-Feb-08 19:23 
AnswerRe: How to draw line on stretched image in picturebox control Pin
Martin#14-Feb-08 21:35
Martin#14-Feb-08 21:35 
GeneralRe: How to draw line on stretched image in picturebox control Pin
Christian Graus14-Feb-08 21:48
protectorChristian Graus14-Feb-08 21:48 
General"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond".Exception please Help.. Pin
ag4667714-Feb-08 19:04
ag4667714-Feb-08 19:04 
GeneralRe: "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond".Exception please Help.. Pin
Mircea Puiu14-Feb-08 21:55
Mircea Puiu14-Feb-08 21:55 
QuestionHow to fix the column of the Listview Pin
klaydze14-Feb-08 18:50
klaydze14-Feb-08 18:50 
AnswerRe: How to fix the column of the Listview Pin
Giorgi Dalakishvili14-Feb-08 20:32
mentorGiorgi Dalakishvili14-Feb-08 20:32 
GeneralDatetime picker Pin
new2pgrmg14-Feb-08 18:26
new2pgrmg14-Feb-08 18:26 
GeneralRe: Datetime picker Pin
Mircea Puiu14-Feb-08 21:51
Mircea Puiu14-Feb-08 21:51 
GeneralRe: Datetime picker Pin
new2pgrmg14-Feb-08 23:34
new2pgrmg14-Feb-08 23:34 
Generalplaying audio through your microphone Pin
Roger Nomoore14-Feb-08 18:11
Roger Nomoore14-Feb-08 18:11 
GeneralRe: playing audio through your microphone Pin
Christian Graus14-Feb-08 18:19
protectorChristian Graus14-Feb-08 18:19 
GeneralTransparent TextBox Pin
kumar.bs14-Feb-08 18:00
kumar.bs14-Feb-08 18:00 
GeneralRe: Transparent TextBox Pin
Christian Graus14-Feb-08 18:18
protectorChristian Graus14-Feb-08 18:18 
JokeWhen you know it's time to go to bed... Pin
Malcolm Smart14-Feb-08 17:54
Malcolm Smart14-Feb-08 17:54 
GeneralRe: When you know it's time to go to bed... Pin
Pete O'Hanlon14-Feb-08 23:44
mvePete O'Hanlon14-Feb-08 23:44 
GeneralAccess Share folder in c# Pin
mimimimilaw14-Feb-08 15:50
mimimimilaw14-Feb-08 15:50 

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.