Ahhhh! that answers the question thanks so much 😀

Thanks for replying but my problem is not in modifying the mdf file name. When it is in the prod server file name is database_data.mdf but when I back up...

Glad it works 🙂

it's been soooooooo long since I last open my account :hehe: thanks for sharing your idea at least it is proven to run sql 2000 to sql 2008 restore procedure...

Ok Noted Thanks 🙂

Thanks for the reply lowell. In another case of my officemate (he uses the same machine but different profile) the SQL groups are there in the EM but when he...

I'm glad it worked for sql version 2008. The only difference is the schema of the tables in sql 2000, 2005 and 2008 🙂

try this...

sp_mshelpcolumns 'table_name'

in the result, search for the col_identity column if value is 1 then that column has an identity

Does the script above available for sql 7 and/or 2000?

In situations like this can I take the database to offline mode then take it to online mode?

I think that is what causing the error since you are in case sensitive mode. Try changing the created tables with the actual table listed by Microsoft in the web...

I'm glad it works!!! 😀

Sorry for the late reply refer to the previous post in this thread. You will see 1 member posting the 2 table schema of the tables you are saying. Change...

For Data File Space run

USE [DatabaseName]

DBCC SHOWFILESTATS

Result Computation

DB Size - (totalextents*64)/1024

DB Used - (usedextents*64)/1024

DB Space - (DB Size) - (DB Used)

For Log File Space run

DBCC SQLPERF(LOGSPACE)

sql_Reporter (11/18/2008)

---

Here is my try at this, the code runs ok but it does not create a folder for me ?

Any ideas

declare @MD varchar(100), @Path varchar(100),@wk_novarchar(2)

set@wk_no = datepart(wk,getdate())

--print @wk_no

SET@Path =...