TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Faisal Ansari
NA
451
833.3k
How to attach database(.mdf) file from network drive sql2008
Jan 8 2014 12:14 AM
hello guys how r u ?
i have cut and pasted the mdf and ldf files of my database from SQL server DATA folder to network drive so how can i attached database from there ...
i am trying this code:
Create database [TestDB] on
(FILENAME = N'\\123.123.1.123\EDMS\DB\TestDB.mdf' ),
(FILENAME = N'\\123.123.1.123\EDMS\DB\TestDB_log.ldf' )
for attach
go
this ip address is just for example..
but above code is giving error
Directory lookup for the file "\\123.123.1.123\EDMS\DB\TestDB.mdf" failed with the operating system error 67(The network name cannot be found.).
Replyy soon
Thanks.
Reply
Answers (
3
)
how to calculate business hours between days on sql server 2008r2
query help ???