I looked at my drive and I didn't find anything accept data files for our db,How can I find out if any of the db are growing very quickly.Thank you

What code can I run to see how much each db space is using space.

Thank you

I found .mdb file with 19,717,120 kb for today, what kind of file is that?

When I ran the query,it wasn't running slow

vv

Here is my results.What should I look for?

Sorry, I posted here

Just to understand clearlerly.

1.The only way in 2000 to run optimization job:is offline?

2.If I remove the maint plan and add a manual script that only...

It is 2000 edition, it locks all of the tables in the database.Reorginizes data and index pages.Change persantage to 10 of free space per page.

It is located in when I go to the db property under Files. I see: Log file that I don't need, when I click remove,I get an error message, that...

I know how to move file using Windows exp,i thought it is another way under OS. I think there is another process on moving system db from one location to...

Questions:

1.How to - move the files at OS level?

2.Do you have a link how to move system db? Is master db has a different process?

Ok, I ran this statment

1.declare @sql nvarchar(max)

set @sql = ''

select 'alter database [' +db.name + '] modify file (name = ' + al.name + ', filename = ''' +

'PUT...

I have another stuped question, in my directions it says:

Physically move the files and full-text catalogues of the database. Is this mean That I have to do ctrl X from...

USE master

GO

ALTER DATABASE dbname

MODIFY FILE (NAME = logical_name, FILENAME = ‘new_path\os_file_name’)

GO

What is logical_name mean?

Thank you for providing me a code, I still need help.

1. I went to the server property and change database settings for Data and Logs to:E:\MSSQL\DEV_OLP

2. I need to...