Go Back   Velocity Reviews > Newsgroups > MCSD
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

MCSD - sql server problem

 
Thread Tools Search this Thread
Old 04-17-2004, 09:11 AM   #1
Default sql server problem


hi all,
i am sapna and preparing my mcsd exams. i am having a
problem to backup a database in sql server 2000. actually
that database mdf file size is 400 MB but ldf file size is
more than 1 GB, so cnnot take backup. some error msg comes.
what to do for it. plz guide
thx



Sapna Chauhan
  Reply With Quote
Old 04-17-2004, 10:46 PM   #2
Syanide
 
Posts: n/a
Default Re: sql server problem
truncate the logfile and shrink it.. --> the 'ldf' file

dbcc shrinkfile <<-- to shrink it

"Sapna Chauhan" <> wrote in message
news:031401c42453$85d71f50$...
> hi all,
> i am sapna and preparing my mcsd exams. i am having a
> problem to backup a database in sql server 2000. actually
> that database mdf file size is 400 MB but ldf file size is
> more than 1 GB, so cnnot take backup. some error msg comes.
> what to do for it. plz guide
> thx
>





Syanide
  Reply With Quote
Old 04-23-2004, 12:54 AM   #3
alex
 
Posts: n/a
Default sql server problem: Solution...

hi sapna, how are u, well this is my first writing and i
hope that be usefull.
your log file is to large and its not so necesary that be
like that ( by the way, my english is not good )

you can deattach your database, then remove your log file
and attach it again... this are the steps USIGIN THE SQL
SERVER MANAGER:

SQL server manager:
1. Deattach your DB. Rigth click over the database name
2. All tasks--> deattach.

at file system level:
3. "backup your log file" just changin the name DON'T
ERAESE IT just in case to need it again.

sql server manager:
4. rigth Click over the sql server' registration name
5. all tasks-->attach database
6. it'll ask u if u want to recreate the log file. should
say yes
7. end

it'll recreate the log file with a size of 1KB, then try
to bakcup your database again.

just in case that this don't be succesfull:
rename again your log file to the original name and
from step 4
step 6 change to: define the log file route to the
original file.
7 end.

that's all

i made this work many times with out problems.
see ya, bye!


>-----Original Message-----
>hi all,
>i am sapna and preparing my mcsd exams. i am having a
>problem to backup a database in sql server 2000. actually
>that database mdf file size is 400 MB but ldf file size

is
>more than 1 GB, so cnnot take backup. some error msg

comes.
>what to do for it. plz guide
>thx
>
>.
>



alex
  Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Prerequisites 70-745 (Business Intelligence) Valmont MCITP 3 06-24-2008 03:03 PM
SQL Server 2008 delayed into Q3 2008 darrilgibson@cox.net MCITP 0 01-27-2008 10:26 PM
MCITP SQL Server 2005 or SQL Server 2008 Darrilgibson@gmail.com MCITP 0 12-19-2007 01:56 PM
SQL Server 2005 Migration Assistant Autonumber problem. LarryWestMCSD MCTS 1 03-28-2007 02:08 AM
Re: Need Ideas For A New Server, Long Post Gareth Church A+ Certification 2 07-27-2003 12:46 PM




SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46