(Please Rush)
Hi all,
I am using SQL SERVER 2000 now, and my SERVER is still have about 27 GB but in my database is saying only 3.4 MB left, I was trying to shrink my database but it is still did not give me more space.
Do you know any way could help me to extend more spaces for my database?
I also included the picture so could help you more
Thank you very much
vdang (vdang2003@sbcglobal.net)
I've created a local server from Sql Express, and report server from Reporting service configuration manager, and than publish a report on the local report server. I want to give access to the other computer user to the sql reports, database and report server.
View 0 Replies View RelatedIs there a way to give someone the right to create only views and no other objects in a database? Currently I have given the individual ddladmin database rose, but would rather be more restrictive?
View 1 Replies View RelatedI am using Microsoft Visual Web Developer 2005
Here are the steps I used to create my database
Tools -> connect to database -> Select datasourse - Microsoft SQL Server (SqlClient) -> Server name - comp4_8SQLExpress -> Log on to the server €“ Use Windows Authentication -> Connect to a database -> Select or enter a database name €“ MyDataBase
comp4_8 - is the name of my computer. I am using Windows XP Professional SP2. Login as administrator without password.
Now about the problem I have. On local machine everything is great! But I hosted my website and got this error. The question is how to give permission to this user to connect to my database.
Cannot open database "MyDataBase" requested by the login. The login failed.
Login failed for user 'ANGELINAASPNET'.
I'm trying to create a report which would give the latest transaction on a database, which all sit on different servers. I wanted to know if there is an a simple way tracking the latest transactions instead of getting the information from the database tables.
View 3 Replies View RelatedI have an ASP.NET application that runs under the development server. Before deploying to my host I wanted to test it under IIS. I set up a virtual directory under IIS, but when I try to open the home page I get an error Unable to open the physical file
"E:CDiskLocalWebSitesDIWSchedulingApp_DataDIWDB.MDF". Operating
system error 5: "5(Access is denied.)".and a code dump showing that the code is breaking at the open connection. A little research on the error indicates that IIS does not have permission to execute the database operation. I can not find any information on how to give IIS this permission in SQL Server 2005 Express. Any guidance would be appreciated.
Need to create a user in sql server provide grants to few system tables to the above user.
View 10 Replies View RelatedAfter SQL Server 2005 Database Engine is installed by domain administrator, how to give permissions to a regular domain user so that user can control SQL Server Database service?
View 3 Replies View Related
Hi all
Iam working in Prodcution ENV,Please help how make space
The log file for database 'Home_alone' is full. Back up the transaction log for the database to free up some log space.
Hi,
Does anyone has query to give all table sizes on a database?
Appreciate your help.
Thanks
Hi, I work on SQL Server 6.5,
and I want to make a documentation about available space of my databases.
So, I must know how many databases space used everyday ?
If somebody know how to get this available space or how to make this script.
I hope you want to tell me about this.
Thanks you so much for your cooperation.
hiiii would appreaciate if somebody can help me to figure how can I monitor my database space used, available bu using Transact SQL through SQL Analyzer...
Thanks
When I go to the GUI in Enterprise Manager to check the space used by my database it says 11,790.05. It also says that my database is 13GB.
My database`s size should be 10GB and my log space is 3 GB.
Is this a case where my database is full and is using space in my log?
Is there another way to detemine how much space my data is actually occupying?
Thanks,
Bob
Hi !
When i try to check the space used in one of the databases in my server
I don't get the correct statistics on the bar graph. The statistics show that the database size & the space used are same.It is not the same for all the databases.
The database size is 17500MB.I did increase the database size to 18000MB
but the situation has not improved.
I tried running the sp_space used and i get the following output:
database_name database_size unallocated space
------------------------------ ------------------ ------------------
VSI 18000.00 MB -3553.26 MB
reserved data index_size unused
------------------ ------------------ ------------------ ------------------
22070542 KB 19325744 KB 2689192 KB 55606 KB
Why does the 'unallocated space show in -ve ?
Also, the database size as u can see is 18000MB but the reserved space shows 22070542MB.
Now i have a new problem, the Log also seems to have run out of space.
when i run the dbcc sqlperf(logspace) i see that the space used is 100%.
Please help.
Thanks in advance
Siv
Is anyone knows how to get the space used for both the data and the log
of a database using the system tables ? I was able to get the database size
but don't know how to compute for the space used.
Thanks in advance.
Vic
Hi
My sql database is showing space available for one of the database is 0.
I have got SQL Server 2005 Ent. Edition(32bit). File growth for .mdf file is set to Autogrowth 10% growth Unrestricted.
I have got lots of physical space on hard drive, why then it is showing 0.00 space available for database. What do i need to do to free up space.
When i ran sp_spaceused it gave me following results
database_name database_size unallocated space
XXXX 1817.31 MB 0.00 MB
reserved data index_size unused
1860760 KB 1763496 KB 13240 KB 84024 KB
I would really appreciate if anyone could tell me what is going on over here and would this slow down the data access?
Regards
Mits
What is the best suggestion to do if a database is using more than 95% of its space. Should I leave it as is and it will grew when it needs? Or do an action. What action?
Is your solution the same for log file as well?
Thanks,
Canada DBA
Folks:
One of my user database has grown to almost 50 GB and most of the space is used by these 2 user tables. The number of rows has in each table is around 5500, but the reservered is very high. What can be done to reduce the space so that my database growth can be brought down.
WorkAssignment - Records: 5492, Reserved (KB): 46586448, Data(KB): 46581264, Indexes(KB): 152, Unused(KB): 5032
WorkUnit - Records: 5634, Reserved (KB): 15072016, Data(KB): 15065840, Indexes(KB): 152, Unused(KB): 6024
Thanks !
Is it possible to select the available space of the database in a microsoft sql MSDE edition?
With sysfiles i can see the size of the database but where can i find the available space or the used space of the database.
Hi
Please help me in resolving the proble.
Database properties showing space available for database is 0.00mb
physical available space on HDD is around 32 GB... Db size is 5gb...but im bit worried about the size what is being displayed....
Settings in my database
General
1) Size of db: 14306.45MB
2) Space available: 0.00MB
Data Files
1) Automatically grow file
2) File growth By Percent: 10
3) Maximum file size: Unlimited file growth
Transaction log
1) Automatically grow file
2) File growth By Percent: 10
3) Maximum file size: Unlimited file growth
Options
1) AutoShrink
I'm worried about this "space available: 0.00MB". What kind of impact will it create?
If I set all settings to unlimited file growth, does it mean my database can grow as big as my physical harddisk space allows? Does this also means I do not have to worry about database allocation?
Please help me
Hi there,
When SQL Runs out of space, I find that once you clear some more space on the drive, a reboot is necessary otherwise web applications will time out once there is a substantial amount of load on the server. Has anyone else find this to be the case and if so Im just curious why this is so?
Very new to the world of databases. Our current database situation is a train wreck, but I'm not at the point I can fix it. So, all I'm trying to do right now is copy our 'live' database so that we can use the copy for development, without worrying about blowing things up.
Anyhow, the problem I have is that when I backup, and then try to restore the 'live' database, I'm told the drive doesn't have enough space, which is accurate (only has 1gig, needs 3gigs). FYI, EVERYTHING that has to do with our databases is currently on a 14gb partition, of which 13gigs are being used. There is an empty partition of 120gb just sitting there.
Can somebody tell me what is the best way to get this 3gb development database up? I tried to route the Data and Transaction Log paths to the empty partition, but it still seemed to want to mess with the 14gb partition and told me there isn't enough space when I tried to restore.
I want to use RAID 1 for System database with sQL Server 2005 64 bit.
Not including TEMPDB.
Is there any point(s) or fact that i should be aware of before I decide on space requirements for system databases(not including TEMPDB). and what should be recommended space keeping in mind the future growth for system databases.
or any factor(s) that can trigger size increase in them.....!
Many Thanks,
Hi,
I am trying to do this:
UPDATE Users SET uniqueurl = replaceAllEmptySpacesInUniqueURL('uniqueurl')
What would be the syntax.
Any help appreciated.
Thanks
I am generating a Report from Sql Data Source in Sql Server 2005 and viewing the Report in Report viewer control of Visual Studio 2005.
The data in the Data Source contains string with multiple spaces (for example €œ Test String €œ) but when they get rendered in Report viewer control, multiple spaces gets converted to single space €? Test String €œ.
I tried following solutions
1) Replacing spaces with €œ €?
2) Inserting <pre> tag before the string and </pre> tag after the string (Also tried <Pre> instead of <pre>)
But in all the cases result is same. The Report Viewer control is showing €œ €? instead of space and €œ<Pre>€? tag instead of preserving spaces.
Please provide me a solution so that spaces can be preserved in Report Viewer.
I am using the below script to get space alerts  and now i am interested in sending alerts  if for any drive space available is Less than 10% or 15%.. how to convert beelow code to find in %Â
Declare @Drives Varchar(20)
DECLARE @Spaces Varchar(50)
DECLARE @availableSpace FLOAT
DECLARE @alertMessage Varchar(4000)
DECLARE @RecipientsList  VARCHAR(4000);
CREATE TABLE #tbldiskSpace
[Code] ....
I have an SQL 2000 database with several tables that are populated using various forms. One or more of the forms is causing the several fields to fill in with data input plus empty spaces to the right for the full character length assigned. Is there a routine or database feature in Visual Studio that can trim off all trailing spaces in all fields in a database table? Is there a compacting routine that might be called?
Thank you
I have a question on database size, specifically, what difference would I expect in the size of a db (the space actually used for data, not indexes) if I have one single data device vs. multiple data devices spanned across different physical drives. I have 2 customers that have identical database tables (all columns are integers), customer A has 27 million rows and customer B has 36 million rows. If I do an sp_spaceused on the table, customer A's data takes up 9.7 gig, whereas customer B only takes up 3.2 gig, even though it has 9 million more rows. Statistics have been updated, so I'm confident the sp_spaceused is accurate on both databases.
The only differences I can see between the 2 databases is that customer B has 5 separate data files (6 gig each) for the database which are part of the Primary filegroup. These files are all on the D: drive, which is a partition on a RAID 5 array. Customer A has a single large data file (24 gig), which is also on a RAID 5 array.
Any ideas?
The transaction log takes up a lot of space on my database, and even after I try truncating the log, doing a transaction log backup, and then shrinking it, I am not allowed to reduce the size of the transaction log to less than 250MB. Is there some reason why this space is required?
View 1 Replies View RelatedI need to be able to obtain the storage space used for database log files.
I can do this in version 6.5 but have been unable to accomplish this in version 7.0.
Does anyone have a suggestion?
Hi,
I have to rebuild a clustered index.I want to know how to find out the free space in a database ?
I know that DBCC SQLPERF ( LOGSPACE )
will give free space in a log space.
Thanks,
copernicus.
Hi All,
One of the drives that stores the database file is close to running out of space. The chance of me getting more space added to this drive any time soon are really low. What are other options I have?
Thanks.
6.0
6
1 SQLCHAR 0 7 "" 1 Ord_Nbr
2 SQLCHAR 0 1 "" 2 Ord_Type
3 SQLCHAR 0 3 "" 3 Locn
4 SQLCHAR 0 16 "" 0 Po_nbr
5 SQLCHAR 0 2 "" 0 Vers
6 SQLCHAR 0 4 "" 6 Int_Code
7 SQLCHAR 0 1 "
" 0 RT_Req
I am using bcp to import data into a table usign format file. when I put 0 in the table column(as it is shown here) it means that I am not bcp in the field values into the table. what I get in return is (NULL) for all those columns that has 0 in the format file.....
My Questions is Am I saving space in the table when I use this process, or (NULL) will take space like an actual value ?
I hope I explained my question clearly... Thanks for your input
regards
Ali