ADSM-L

Re: SQL full backup plus log

2004-09-14 14:31:59
Subject: Re: SQL full backup plus log
From: Joe Crnjanski <JCrnjanski AT INFINITYNETWORK DOT COM>
Date: Tue, 14 Sep 2004 14:31:27 -0400
If we are talking about SQL 2000;

Go to Enterprise manager; expand tree sql server group; server name; databases; 
database name. Right click and go to properties for database. In Options tab 
you will see recovery model. Change it to full.

While you are there click on help and search for "Transaction log backup".

Joe Crnjanski
Infinity Network Solutions Inc.
Phone: 416-235-0931 x26
Fax:     416-235-0265
Web:  www.infinitynetwork.com



<Prev in Thread] Current Thread [Next in Thread>