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