Home > Sql Server > SQL Server 2000 Question

SQL Server 2000 Question

INSTEAD OF trigger.B. When it occores, check the DB and see why it grew. then leave it alone. Hope this helps. navigate here

Please Answer when you saw my question , I'm waiting . Welcome to the Ars OpenForum. Differential recoveryB. Thanks you! 0 · Share on Facebook Sign In or Register to comment. http://www.indiabix.com/database/managing-databases-with-sql-server-2000/

This is not a recommended method for restores, but may be what you need. Leave new Erdal Findik September 19, 2008 2:06 pmHi,I installed recently SQL2008 on a new server. Right click on the DB > Tasks > Shrink > Files > Select the Log > Select "Release unused space" > OK.Edit: to fix this once and for all, run a

BEGIN trigger. I moved my databases from the old server(SQL 2005) to the new one. Going to schedule a backup of that log file every 2 hours. Registered: Mar 15, 2002Posts: 24772 Posted: Thu Apr 03, 2008 10:59 am You need to read up on SQL Server.

Join them; it only takes a minute: Sign up VS2010 Using SQL Server 2000 Ask Question up vote 4 down vote favorite 2 Is there a way to use the SQL You're better do a reasonably large grow while the system load is at minimum so it won't impact your users. Simple recoveryD. find more Polgar/P.

However, are client licenses being used or accessed when a number of users are accessing the database via a web site application?Any help would be great. brainstem Ars Tribunus Militum Registered: Feb 23, 2000Posts: 1595 Posted: Tue Apr 08, 2008 8:34 am for quick cleanup of something like this, I wrote this script a while back. Sign In Register Categories Recent Discussions Unanswered Best Of... Plan large enough, do a defrag and you'll be fine.Alternatively, you can let the grow happen and make sure you check the log for that event.

I am creating a VM with XP, to see if this process is easier than W10. –Wiz May 2 '16 at 16:03 add a comment| Your Answer draft saved draft https://www.connectionstrings.com/sql-server-2000/questions/ share|improve this answer edited May 2 '16 at 16:05 answered May 2 '16 at 15:09 RLF 12k12039 I have the logs too. After some research, I saw that the best approach is making a .bak of this 2 files. A million things can go wrong with the MDF file. –Ali Razeghi May 2 '16 at 19:27 1 @AliRazeghi probably the files are corrupted, I do not know.

linq-to-sql visual-studio-2010 sql-server-2000 share|improve this question edited Mar 2 '10 at 16:45 Joel Coehoorn 258k92453674 asked Mar 2 '10 at 16:29 Chris McKee 1,64773269 add a comment| 4 Answers 4 active http://recupsoft.com/sql-server/sql-server-2000-notification-services.html Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures? Ask your question now ! © 2009 - 2017 by IndiaBIX™ Technologies. Workspace Report errors ...

StickyDragon Ars Tribunus Angusticlavius Registered: Oct 3, 2000Posts: 7900 Posted: Mon Apr 07, 2008 9:58 am Ah ok, cool thanks for the tips! Would a civilization on a planet with no natural Uranium-235 NEED to first achieve fusion before it can build nukes? The strictest transaction isolation level provided by SQL Server is called: A. http://recupsoft.com/sql-server/sql-server-2000-quad-cpu.html The log had to be shrunk.

Where can I get Database SQL Server 2000 questions and answers with explanation? How does one show that a person or thing is the performer of an action? How to respond to people who overuse punctuation marks?

Alternatively you could create your data access methods in a VS2008 project dll and include that in your 2010 solution. –Mechamonkey May 26 '11 at 14:34 add a comment| up vote

Otherwise, it's that you're having a problem: either someone is playing games with your DB or you're having a problem with your backups. Access 2003SQL Server 2000AccessSQL Server 0 votes 0 answers Pete Zen8 months ago Connecting SQL Server 2000 Database over InternetHow to connect SQL Server 2000 Database over internet? StickyDragon Ars Tribunus Angusticlavius Registered: Oct 3, 2000Posts: 7900 Posted: Thu Apr 03, 2008 9:50 am hmm, I just ran a backup on the DB then a backup on the TLogs, Why doesn't Ctrl-C kill the Terminal itself?

This of course depends on utilization, jobs, processes etc with lots of log activity.Shrinking and growing constantly is not what you want. 13 posts Ars Technica > Forums > Operating Systems Going to schedule a backup of that log file every 2 hours. In a small business I'd run full DB backups at night, the logs backups in the morning just before the office opens, then at noon, then again when the office closes weblink What was the first piece of software to be called an engine?

StickyDragon Ars Tribunus Angusticlavius Registered: Oct 3, 2000Posts: 7900 Posted: Thu Apr 03, 2008 11:28 am Awesome, that shrunk it down to 1028k Thanks a lot. How does one show that a person or thing is the performer of an action? Let us discuss. Please download them and use them in your next interview or just for reading purpose.An interview Question and Answer discussion can be very helpful to both these individuals.  It is simply

pinaldave September 20, 2008 11:26 amUPDATE : Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers. I have gotten many emails about complete series. Why would a civilization outfit buildings with separate portals for entering and leaving them? 240v Outlet with 120v and 215v - How? Answer: Option A Explanation: No answer description available for this question.

But the LDF file (or the DB files for that matter) do not shrink. Name : Email: View Answer Discuss in Forum Workspace Report 3.