mccork,

Thanks for the help. I tried telnet dos command.

ran telnet servername 1433

could not open connection to the host, on port 1433: connection failed

ran telnet servername

cound not open connection to the...

sorry,

I forgot MSDE does not have a SQL interface

right click on the database and go to all tasks, then backup db

I found some sort of Virtual Server Administration page (Microsoft SharePoint Administrator).

Don't know what it is though!

below are two items copied from MSDN, maybe attach mdf, ldf files first then after that is complete use single file attach to attach the log file.

sp_attach_single_file_db

Attaches a database having...

I am using mixed, I have created a dsn, I have created the IUSR in SQL and given it permissions. I have not set any folder permissions to IUSR. I...

check this link out:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q169/3/77.asp&NoWebContent=1

change authentication to mixed(sql and windows)

you could also copy the files in a vbscript using FileSystemObject

If you want it to keep mirroring you will have to write a complex stored proc or dts package. I tried it. My advice is create a job in the...

as long as you detach the mdf/ldf files then copy them to the new location, then reattach the files to machine a, then attach files to machine b. you should...

if you want to see this database on your second machine. you will have to create first create the database, then attach the files to the database using sp_attach_db.

Did you...

Is the new location of the file on the same box(dif. drive)?

I ran the stored proc, set db permissions in SQL.

Still got the same error. Do I have to set permissions to some folders, etc...

thanks

ps.We do not have an admin, just...

When using SQL Query Analyzer:

What DB would I run that proc under...master

Thanks