questions on copying SQL Server database -

-

subquestioning [2]

while copying resource.mdf [1], noticed that:
1)
possible copy resource.mdf without stopping sql server instance (i attached 1 having copied running instance , works after attaching) .

1a)
should understand general possibility read-only databases or in versions (mine 2008 r2 on windows xp pro sp3)?
1b)
conceptually, cannot understand why developing (dev ed) sql server on isolated/workgroup desktop windows (in case - xp pro sp3) should stopped in order copy user-defined non-used (for ex., sample database) database.

1c)
when 1 should copy .ldf .mdf file , when copying .ldf can skipped?
why read-only database have (transaction log? understood) file ldf?

2)
resource.mdf (in sql server 2008 r2 on default unnamed instance, windows xp pro sp3) in

  • %programfiles%\microsoft sql server\mssql10_50.mssqlserver\mssql\binn\

and not in

  • %programfiles%\microsoft sql server\mssql10.sql2008\mssql\binn\ [2]

i curious - location differing due sql server version, edition or windows edition, version?

[1]
question "how see/script definitions of system views?"
how see/script definitions of system views?
[2]
martin smith's answer [1]
how see/script definitions of system views?

if database has auto_close turned on engine close file handle when database no longer in use. express instances create databases auto-close on , property preserved when database attached non-express instance.

it not true have shutdown instance copy database file. have relinquish exclusive handle held sql server instance on database files(s). can done setting database offline, copy, setting online. (if remember correctly) databases read-only, handle held sql server allows processes open shared handle on file. why can copy online read-only database, , msqlsystemreource read-only under normal operating mode.

other questions:
1c) never. copy mdf, ndfs , ldf(s). when there recomendations copy mdf alone, ignore them , copy ldf well.
2) resource databases part of binaries. in binn folder of installation, same location sqlservr.exe. path differ each installed instance , can change during setup.

and 1 last consideration: why touch resource db? world of pain, may corrupt instance if manipulate resource db in way.


Comments

Post a Comment

Popular posts from this blog

ASP.NET/SQL find the element ID and update database -

-
basically i've got update query runs when click submit button. i have asp:repeater in page layer inside this <asp:repeater id="dgbookings" runat="server" onitemdatabound="itemdb"> <itemtemplate> <div class="bookingscontent"> <div class="bookingdetails" id="<%# databinder.eval(container.dataitem, "booking_ref") %>"> <p class="infotext"><%# databinder.eval(container.dataitem, "adults") %> <asp:linkbutton onclick="editdetails" text="edit..." runat="server"></asp:linkbutton></p> <p class="infotext"><asp:linkbutton onclick="submitdetails" text="submit..." runat="server"></asp:linkbutton></p> </div> </div> </itemtemplate> <asp:repeater> and outputs ...
Read more

jquery - appear modal windows bottom -

-
i have modal windows in application, work fine <div id="modal" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="mymodallabel" aria-hidden="true"> but when modal appears, appear top of windows, , want appear bottom the application joomla 3.0! , using template of meet gavern any idea? i found solution i modified de css in bootstrap .modal.fade { top:-25%; -webkit-transition:opacity .3s linear, bottom .3s ease-out; -moz-transition:opacity .3s linear, bottom .3s ease-out; -ms-transition:opacity .3s linear, bottom .3s ease-out; -o-transition:opacity .3s linear, bottom .3s ease-out; transition:opacity .3s linear, bottom .3s ease-out; }
Read more

c++ - Compiling static TagLib 1.6.3 libraries for Windows -

-
i having super hard time compiling , using taglib 1.6.3 in qt project. i've tried can think of. taglib claims supported through cmake i'm not having luck. furthermore, i'm confused kinds of files need qt libs! i've built *.a files, *.lib, , *.dll. understand far... believe since i'm working in windows *.lib want. no matter do, end "undefined references" taglib functions try use when try compile qt project. have tried mingw32, msys, visual studio 2008, , cross-compiling windows on linux. turning nothing. what makes less sense me if compile same taglib source qt on mac (g++ think?) works fine! somewhere in windows compilation procedures have going wrong. have been smacking face on desk 30 (on , off) hours trying figure out. since qt uses mingw must compile taglib same compiler? if compile *.lib's visual studio not compatible? are *.a libraries usable in windows? (assuming mingw) i'm still trying handle on c++ stuff, after reading coun...
Read more