What is the best practice for free space for a SQL server database drive?
Let’s learn what is the best practice for free space for a SQL server database drive. The most accurate or helpful solution is served by Database Administrators.
There are ten answers to this question.
Best solution
I'm trying to determine the best practice for sizing a single database on a 120Gb data drive that will contain the LDF and MDF files. I'm assuming that I don't want to set the size to be the maximum size of the drive, allowing room for moving and reorganising the data. I don't want to let it expand automatically either. I'd like to set the size to something sensible and clear out the data regularly. Can anyone provide any guidance? EDIT: some additional data... The database is set to "...
Answer:
I'm trying to determine the best practice for sizing a single database on a 120Gb data drive that will...
TeamWild at Database Administrators Mark as irrelevant Undo
Other solutions
Please help me understand what happens when I click the cancel query button in SQL Server Management Studio. Please help me understand what happens when I click the cancel query button in SQL Server Management Studio. I was running a delete query in...
Answer:
The deletes won't be committed. You're running out of disk space because it has to log all of those...
smithygreg at Ask.Metafilter.Com Mark as irrelevant Undo
I have an application whose database will soon grow beyond the 2TB limit of its disk drive. I have additional drives available to me, each with 2TB of space. What I would like to do is split this database across 2 drives, with some of the tables on drive...
Answer:
Here's a discussion on MSDN with appropriate links on how to add files and use DBCC SHRINKFILE to force...
DWRoelands at Ask.Metafilter.Com Mark as irrelevant Undo
I need a provider who gives MS SQL server database space. My present web hosting provider gives only 200 MB which is not sufficient. i need at least 1 GB. No need for a web hosting company, I need only dedicated database service provider.
Answer:
You might want to rent a cloud server from Rackspace or Amazon. Rackspace has cloud servers starting...
amazingp... at Yahoo! Answers Mark as irrelevant Undo
I am a student, major in database management. On my 5th semester, we are required to create a system using heterogeneous database. We must use at least 4 different database. My choice would be MySQL, MS SQL Server, Oracle and PostgreSQL since these...
Answer:
The heterogeneous database connection is only theoretically feasible, but unfeasible in practice because...
David Jin at Quora Mark as irrelevant Undo
DROP TABLE logs/#sql-ib203 does not work due to '/': Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/#sql-ib203' at line 1 The table logs/#sql-ib...
Answer:
You can quote object identifiers with `backticks`, however "logs/" is the directory for the...
Rob Johnson at Quora Mark as irrelevant Undo
Hi there-- Just looking for a little guidance here. I work for a small law firm, and we currently use a software package for practice management (open/closed files, calendar, phone messages). Unfortunately, we have had nothing but problems with the software...
Answer:
All right. First of all. You have a couple of ways to do this. It depends of your company's server wether...
Michael at Yahoo! Answers Mark as irrelevant Undo
Another SQL question (*sigh*), but this time a bit more complicated. There is a column in my database called 'Contact'. It is currently null for about 140k of the 148K entries. There are two other columns called 'Lastname' and 'Firstname' in my database...
Answer:
Paste these into your Query Analyzer: UPDATE TABLE Set Contact = Firstname + " " + Lastname...
omnipotentq at Ask.Metafilter.Com Mark as irrelevant Undo
My computer (vaio desktop) keeps getting the following error message "An error occurred while initializing SQL Server Compact: The specified password does not match the database password. [ Data Source = C:\ProgramData\DDNi\Oasis2Service\Data\O...
Answer:
I had the same problem with my Sony Vaio so I called Sony at 1-800-476-6972. They told me to go into...
Will S at Yahoo! Answers Mark as irrelevant Undo
One of my computer have sql installed in it, My problem is that i want those database on other computer they do not have network connection betweeen them i want to transfer through my pen drive my friend told me that you can do it by enterprise manager...
Answer:
1. open SQL SERVER Enterprise Manager 2. go to sql server 3. Select Management 4. Go to Backup and rightclick...
Nick at Yahoo! Answers Mark as irrelevant Undo
Related Q & A:
- How to connect Sql Server Database from android app?Best solution by Stack Overflow
- How to restrict access to a sql server database from Azure?Best solution by Stack Overflow
- How to import XML into SQL Server database?Best solution by Stack Overflow
- How to change column data's as a separate column wise format in a SQL Server?Best solution by stackoverflow.com
- How do I connect to a SQL Server database?Best solution by Stack Overflow
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.