You can do this in either of the following

options :

1. Take a Database Backup and restore onto new Server.

2. Procedure:

2.a. Stop the SQL Services

2.b. Copy .MDF & .LDF files to...

How are you starting your SQL Server Service? Is it a Domain Account? Or a local system account?

No. But in the server's domain this is the only 6.5 server. We have few 2000 & 7.0 servers in other domains.

Or someone with sysadmin server role.

since this is SQL Server 6.5, I can't use DTS.

Thanks spongemagnet for your response. I even saw this kinda script earlier. But didn't remember where... I tried searching thru the script library here, but .... :-((

Sill by 2nd question...

If you want to expand the file, you can expand the database device for master, then expand the master database by using this device file.

But if you want to decrease...

What error are you getting?

I have installed on Windows 2000 Server recently. But not sure about Windows 2000 Advanced Server.

There are several places you can check.

1. Right click on the job--> View Job History

2. You might see the error sometimes in \Microsoft SQL Server\MSSQL\LOG\ERRORLOG

3. You might see the...

I am new to SAN. Can someone shed some light on this? It is my understanding that its a high end fileshare.

Similar & Relevant post...

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=16123

Some projects, they have different groups like Dev Support and Prod Support. In this case, I Don't give access to developers. That will be very very rare. I grant SELECT...

I would prefer Prod. Support Personnel only will have READ-ONLY access to production database. For this on SQL 6.5 I have ProdSupport Group, which will have all SELECT on all...

But again Lumigent Schema Alert need to be installed in any one of the client machine for monitoring. Also it should be up and running at that time. I use...