Re: DB export/Import looses users - SQL7

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 05/17/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Fri, 17 May 2002 08:11:54 -0400

That is certainly not the way you want to go about reducing the size of your
log file. Take a look at DBCC SHRINKFILE in BooksOnLine for a better
alterative. If it is growing too large then you should either increase your
backup interval on the log files or set the recovery mode to Simple. If
you have deleted the DB then there is no way to get those users back unless
you manually re-enter them. You can use EM to script out all the parts of
the database before you delete the DB. Right click on the Database and
choose "All Tasks" and then "Generate SQL Script". One of the tabs will
allow you to script out the users. 

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.
"Pete Dowling" <Pete.dowling@uk.nestle.com> wrote in message
news:488a01c1fd82$0377c040$3bef2ecf@TKMSFTNGXA10...
> The transaction log was too large, so I deleted the DB &
> re-created the DB to retrieve & re-size the transaction
> log. But, the users were deleted.
> Pete
> >-----Original Message-----
> >The data has nothing to do with users.  The users are
> attached to the
> >database not the data or a table.  A user can be an
> object owner but they
> >belong to the DB.   How are you importing these?
> >
> >--
> >Andrew J. Kelly   SQL MVP
> >Targitinteractive, Inc.
> >
> >
> >
> >"Pete Dowling" <pete.dowling@uk.nestle.com> wrote in
> message
> >news:3e8b01c1fcd9$5ecb0230$b1e62ecf@tkmsftngxa04...
> >> Can I export / import db users ?
> >> When I export & import tables & data (to retrieve
> >> transaction log space), all users are dropped, and have
> to
> >> be re-created - can users be exported ?
> >> Thanks
> >> Pete
> >
> >
> >.
> >

Relevant Pages

  • RE: Shrink File?
    ... As my understanding of you problem, you have a database with a data file ... in the log file. ... You can truncate only nonactive portion of the transaction log. ...
    (microsoft.public.sqlserver.setup)
  • Re: Purge Interchange DTA - HELP!!!
    ... Have you set up the "Backup BizTalk Databases" script? ... BACKUP LOG BizTalkDtaDB WITH TRUNCATE ONLY ... Note that this will truncate the log file of the DB - if your backup strategy relies on it, you are in trouble and should back it up beforehand. ... My InterchangeDTA database has become so large that the ...
    (microsoft.public.biztalk.server)
  • Re: optimum log file size
    ... Fixing of Transaction log file based up on the amount of bulk transaction ... CUrrent log growth will be because of FULL recovery mode. ... If you do not require a point in time recovery or if your database ...
    (microsoft.public.sqlserver.clients)
  • Transaction log problems
    ... just before you backup the ... database change the recovery model to ... Simple, shrink the log file then change it back to Full, ... >transaction log and it is causing us some problems. ...
    (microsoft.public.sqlserver.server)
  • Re: Shrink File?
    ... Cannot drop the database 'wlmpetprodata' because it is currently in use. ... it is normal that your log file is much larger ... > You can truncate only nonactive portion of the transaction log. ...
    (microsoft.public.sqlserver.setup)