Urgent SQL Sever 7 problem

[corosus]

Hi

We have a dedicated OLD box with SQL server seven running on Windows NT server and the partitiono that is used for the data files is almost full (last night i still had 500 mb but today thanks to a error by someon else it's down to 9..94 mb)


there are 3 large file on the disk

a 2 gig Pagefile.sys

a 6 Gig log file

and a 3 gig data file

I don't know the first thing about SQL and we really need this box to run smoothly, can i safely delete anny of these files, or is there a way to make them smaller ???


Greetz and thanks..

[mairving]

Nope you can't delete them. You could possibly shrink the page file but it may impact perfomance. It is pretty easy to shrink the log file with SQL Server 2000. Here is how to do it with SQL Server 7.

[corosus]

thank you verry much mairving,

schirinking the file only gave us a couple of 100 mb , but that was enough room to work with and get rid of the massive log file.

I take NO responsibility for this method, but in our case it works out fine

sp_detach_db @dbname='yourdatabase', @skipchecks='false' Move logfile to a different location on the network sp_attach_single_file_db @dbname = 'yourdatabase', @physname = '-Path-to-your-MDF-file' DBCC REBUILD_LOG ('yourdatabase','-Path-to-your-LDF-file') restart the machine to make sure all the agents work

[faulkner132]

If you put the database into "Simple" mode (in the Database properties inside of Enterprise Manager), it will keep the log file from growing larger than a ~100 MB.
If you do this though, you will need to make sure you do FULL SQL backups (i.e. a BAK file) instead of transactional log backups.

[mairving]

Originally Posted by faulkner132 If you put the database into "Simple" mode (in the Database properties inside of Enterprise Manager), it will keep the log file from growing larger than a ~100 MB. If you do this though, you will need to make sure you do FULL SQL backups (i.e. a BAK file) instead of transactional log backups.

Are you sure about that? I know that works in SQL Server 2000. I am not so sure about version 7.