Thursday, March 29, 2012

create and attach data base

Hi, i want to create a database with out the LOG file I did not find a way to do that, I want to create database in 2 ways

1. With CREATE DATABASE command.

2.Attach an exsiting MDF file.

is there any way i can do that, my problem is that i'm creating the data base on my local computer the using sp_detach_db to detach the DB files, then trying to attach DB files from remote computer on the LAN that i dont have write premmsion on, but then i get an error from SQL server saying:

"[Microsoft][SQL Native Client][SQL Server]Unable to open the physical file "\\lab11\sqltest\pppSignaling_log.ldf". Operating system error 5: "5(Access is denied.)"."

what can i do to solve this problem?

thanks ishay

More about storage in network path in SQL Server can be found here:

http://support.microsoft.com/kb/304261/en-us

Generally spoken, this is not supported.

HTH, Jens Suessmeyer.

http://www.slqserver2005.de

No comments:

Post a Comment