on 06-02-2010 10:58 AM
In of our servers it is BI7.0 on Sqlserver 2005 and windows 2003 the disk is almost full.Could anyone assist in cleaning up of the system so that we can start the system.As of now we cannot even start the system.Thanks.
Perform this steps:
Log on to the Server as Admin> double click drive> CTRL+F> on the left pane you'll see All files and folders> expand "What size is it"--> search for files "SPecify size 10000 KB and post the files which are cosuming the space.
I will expalin you what to do.
Thanks
Manny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi dudes!
First at all, please NEVER EVER delete any database file on the OS level!! You won't be able to do so, unless the SQL Server is stopped in which case you will DESTROY your database!!
Instead of that, just backing up your transaction log (TLOG) should be enough to considerably reduce the data in your TLOG, and then you will be able to shrink it. You can check notes *625546* +(Size of transaction log file is too big)+ and *421644* +(SQL error 9002: The transaction log is full)+.
Regarding your original question, and assuming that after backing up and shrinking the TLOG is not enough to run your system smoothly, you could consider shrinking also your datafiles. However this is usually not interesting and could hinder your performance (regarding this particular, please refer to [this post|, and even it would just be a workaround, as sooner or later you will exhaust your drive space.
The real solution is to add more disks to your file system and then add more data files to your database or move some of the existing ones. In this sense, please refer to *note 363018* +(File management with SQL Server)+.
And also a very important task is to reduce your tables by deleting useless information. In this sense I can only recommend you a very nice note for Basis tables, i.e. *note 706478* +(Preventing Basis tables from increasing considerably)+.; regarding application tables, I cannot tell you any suggestions, but maybe you can search for other SDN threads if you find any huge tables that should not be so extense.
At last, please remind to check always the +Microsoft SQL Server 2005 *Books Online (BOL)*+.
Cheers!!
-Jesú
This is a very basic question.
you should refer to SAP training. Go for SAP course ADM100...
or search SAP notes:
SAP note 16513 File system is full - what do I do?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1. Are you using RAID for your server ?
(I think, you must be !...)
2. Is it Hard RAID or SOFT RAID ?
You can extend disk space by adding another Hard Disk in existing RAID array on which oracle database filesystem is reside.
For this you can consult with your System Administrator.or Hardware Vendor in case of Hardware RAID...
I don't think there is any other way ...
Regards.
Rajesh Narkhede
Hi,
Then you have 2 options.
1. If your have multiple physical drives and database is installed on separate drive, you can take NTbackup of that drive. Add higher capacity drive to server and restore the database backup (NTbackup) on new drive. Once done change drive letter of the newly added drive as original.
2. You can add another disk in server and define RAID5 on your server. It will increase the total available space.
If you search google "how to create RAID5 in windows" you will get several link explaining step-by-step process...
I don't think there is any other way to overcome this problem, except taking complete backup (Data and System state) and restoring it on new higher capacity drive.
Regards.
Rajesh Narkhede
> In of our servers it is BI7.0 on Sqlserver 2005 and windows 2003 the disk is almost full.Could anyone assist in cleaning up of the system so that we can start the system.As of now we cannot even start the system.Thanks.
Which disk is full?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.