we upgraded software

Thanks to every one, it helped me a lot.

we upgraded the software version, and the problem is only while running the queries, even basic queries are running slow.

if its a problem of indexes how do i need to...

yes i am doing manually, and i dont know how to dedicate ports you are talking about.

This query will return ALL databases and their respective file location

use master

select name, filename, dbid, convert(char(12),crdate)

from dbo.sysdatabases

where sid <> 0x01

order by name

Thanks Grant Fritchey,

It helped me a lot. I have a problem in creating a view for my production db, i cannot post it here, if you can help me pls...

Monitor Database Growth

This code provides a way of monitoring the growth of all your databases within a single instance. The first part is the creation of a monitoring table with...

Thanks

but do you have any suggestions without a third party tool.

Thanks,

I guess you are right, I thought of somthing else. I have a table and my manager wants to update that column, so...

i am not restoring it, i am trying to give the backup path, anyways thanks for your reply, let me know how can you add a drive

In my case, the...

thanks for your reply,

I did in that way, but the problem again is there are 4 drives, but when i am adding the new path its showing only 2...

thanks, but is this possible to do that, i dont know exactly where to put the copied pathname you are telling, in which dialog box, More over when i specify...

I did it with the export data wizard, because i wasnt able to restore the backups from the shared drives. Now the databases are moved successfully to another server.