February 25, 2002 at 8:41 am
Hi
I want to reduce the log file, size 13 GB
but maintaince backup want run,
how do I manuelly run the backup commands ?
I have found some command line scipts, but
where do I execute them ?
February 25, 2002 at 8:44 am
You can execute T-SQL commands through Query Analyzer. Check out Books Online at the BACKUP LOG command.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
February 25, 2002 at 8:44 am
If you are talking about BACKUP DATABASE and BACKUP LOG then one of the easiest places is to run in Query Analyzer. Also are you wanting to truncate the data out of the log file and shrink or perform a true backup? And what version of SQL are you using?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
February 25, 2002 at 11:43 am
backup database <db name> to disk <disk file path and filename>
backup transaction <db name> to disk <disk file path and filename>
If you need to shrink the log, it doesn't always work because of the virtual files inside the log file. Here's a link to a scrip that will help.
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26
Also, some other scripts:
Steve Jones
February 26, 2002 at 1:14 am
Thanks, for the answers, I will try some of them now,
I am running SQL 2000 with the lastest service pack.
I dont understand why the maintaince plan wont work,
Does the database have to be in single user mode.
February 26, 2002 at 2:02 am
Hi again
When I run the backup commands in SQL Analyzer,
it will not accept the file path, it says error
near f:
If I create a backup device how can I use that.
February 26, 2002 at 5:04 am
The filepath syntax should look like this.
BACKUP DATABASE myDB
TO DISK = 'f:\myDbFull.dat'
Or something similar, just make sure to put path in single quotes.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply