sql - how can i attach an MDF file to a server with the same LDF name? -

-

i have .mdf backup of database. need information .mdf.

when try attach .mdf, requires log file shipped.

i don't need log file, insists on .ldf file.

i tried point same log file shipped, getting error:

enter image description here

(since in use current version of database.)

i unable attach different server because on sql server 2012, , sql server 2012 server.

how reattach .mdf without .ldf?

i adding text version in case else searching solution issue:

msg 5120, level 16, state 101, line 1
unable open physical file "d:\sql logs....custom_log.ldf". operating system error 32: "32(the process cannot access file because being used process.)".
file activation failure. physical file name "d:\sql logs....custom_log.ldf" may incorrect.
log cannot rebuilt because there open transactions/users when database shutdown, no checkpoint occurred database, or database read-only. error occur if transaction log file manually deleted or lost due hardware or environment failure.

msg 1813, level 16, state 2, line 1
not open new database 'testdb'. create database aborted.

i don't know if relevant, not need attach .mdf file if don't have to. need read 1 table there.

if use 2012 use "for attach_force_rebuild_log"

  create database [xxxdatabasname] on  ( filename = n'databasexxxfilepath.mdf' )  attach_force_rebuild_log

Comments

Post a Comment

Popular posts from this blog

c# - Is it possible to remove an existing registration from Autofac container builder? -

-
something along lines: builder.registertype<mytype>().as<itype>(); builder.registertype<mytype2>().as<itype>(); builder.deregistertype<mytype>().as<itype>() var container = builder.build(); var types = container.resolve<ienumerable<itype>>(); assert.istrue(types.count == 1); assert.istrue(types[0].gettype == typeof(mytype2)); scenario: go through bunch of assemblies , go register types want make sure have 1 implementation of given type. need before create container. track on own nice if autofac me bit. this cannot done directly using containerbuilder , unless start on new one. mind you, having first built container should able construct new container filtering away unwanted types , reusing registrations first container. this: ... var container = builder.build(); builder = new containerbuilder(); var components = container.componentregistry.registrations .where(cr => cr.activator.limittype != typ...
Read more

asp.net - Error '2035' ('MQRC_NOT_AUTHORIZED') While Connecting to MQ -

-
i getting error while connecting ibm mq. know because of privileges, there way check connection ibm mq? please suggest. the 2035 suggests connection getting qmgr. if had wrong channel name, host or port 2059. 2035 means connection made listener, found channel of name requested , attempted connection. if want test past point necessary either authorize id using connect or put authorized id in mcauser attribute of channel. for detailed explanation of how wmq security works on client channels, see wmq base hardening presentation @ http://t-rob.net/links .
Read more