Re: How critical is the transaction log file?
- From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 20 Mar 2008 19:08:01 +0100
I would like to give justification to the department of not needing it if
there is.
I'm not sure where you are heading with above. To me it is simple. You don't want to do something which isn't supported according to the product documentation. And, btw, I agree with the other post that a backup might be preferable...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"jonefer" <jonefer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:7268AFB4-E21E-413C-ACC6-DC168D9C9782@xxxxxxxxxxxxxxxx
I just realized that I didn't specify - SQL Server 2000, not that that makes
a difference, but I checked the documentation and it only specifies that you
can do it.
Are you talking about the prerequisite of having detached it?
I would like to give justification to the department of not needing it if
there is.
If there isn't, then I'll just go ahead and send 2 files.
"Tibor Karaszi" wrote:
Check out the documentation for sp_attach_single_file_db. This is what you use to attach a database
file when you have only one file (no log file). This documentation will tell you under what
circumstances it is supported to attach only an mdf file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"jonefer" <jonefer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9C4245C8-8812-4623-ADE2-322D5C84AB72@xxxxxxxxxxxxxxxx
> For deployment purposes, our IT department has allowed us to send an mdf file
> to 'attach' to their server in the interim until our own server gets built.
>
> This development database that we're building does not have any 'user'
> writes to the database, i.e. only DTS will add data to the database.
>
> I've sent the mdf file, 2 weeks in a row not remembering to send the log
> file, but I've recieved no complates from the IT department and they seem to
> have managed ok without the file. And the application runs without a hitch.
>
> I just wondered about ths because finally, somone said something.
> Since we are in a 'development' mode, is this ok? Or should we begin
> sending the transaction log file.
.
- Follow-Ups:
- Re: How critical is the transaction log file?
- From: Rick Byham, \(MSFT\)
- Re: How critical is the transaction log file?
- Prev by Date: Re: How critical is the transaction log file?
- Next by Date: Re: How critical is the transaction log file?
- Previous by thread: Re: How critical is the transaction log file?
- Next by thread: Re: How critical is the transaction log file?
- Index(es):
Relevant Pages
|
