Size for DB in Suspect\OFFLINE

how to check the DB size and other details which is in SUSPECT\OFFLINE mode in SQL Server 2000

asked Mar 01 '11 at 12:21 PM in Default

srivivek
519 ● 30 ● 39 ● 42

(comments are locked)

2 answers:

Look at the file sizes? Find them from the master..sysaltfiles table.

answered Mar 01 '11 at 12:26 PM

ThomasRushton ♦
29.5k ● 6 ● 9 ● 36

thank you Thomas Rushton

Mar 01 '11 at 01:15 PM srivivek

(comments are locked)

According to this the sysaltfiles table has been deprecated.

Use master.sys.master_files instead, and know that the size returned by this table is the number of 8 kb pages in your database file. (BOL)

answered Mar 01 '11 at 01:45 PM

Jos Menhart
222 ● 5 ● 7 ● 7

Way to keep us current :)

Mar 01 '11 at 02:28 PM KenJ

Yeah, but it's a query about SQL2000... which is also deprecated...

Mar 01 '11 at 02:38 PM ThomasRushton ♦

shame, I missed that, completely. Just started databases on SQL 2005 :-).

Mar 01 '11 at 02:45 PM Jos Menhart

@Jos Menhart - you n00b! ;-) Started on SQL 4.whatever... The worrying part is that my most recent SQL 2000 build was just a couple of months ago.

Mar 01 '11 at 02:51 PM ThomasRushton ♦

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

asked: Mar 01 '11 at 12:21 PM

Seen: 386 times

Last Updated: Mar 01 '11 at 12:28 PM