Locks and Blocks: edition

Showing posts with label edition. Show all posts

Friday, March 30, 2012

Log is growing crazy when run DBCC INDEXDEFRAG or DBREINDEX

We have SQL 2K Enterprise Edition with SP3. Server is dedicated database
server used for JDE application. Database size is 100 Gig. This DB is
configured for replication (only 25 tables). This database is also
configured for Log ship to a stand by server where we run our reports.
When we run DBCC DBREINDEX or DBCC INDEXDEFRAG on this database, the log
file start growing crazy, which makes replication and log ship to break.
Our concern is how can we avoid growing log file while DBREINDEX or
INDEXDEFRAG running?
Your response is appreciated.
Thanks,
AbbasBackup or truncate the transaction log frequently during
the processes is the only thing I can think of. Or set
the Database Recovery model to Simple. Any other ideas?
>--Original Message--
>We have SQL 2K Enterprise Edition with SP3. Server is
dedicated database
>server used for JDE application. Database size is 100
Gig. This DB is
>configured for replication (only 25 tables). This
database is also
>configured for Log ship to a stand by server where we run
our reports.
>When we run DBCC DBREINDEX or DBCC INDEXDEFRAG on this
database, the log
>file start growing crazy, which makes replication and log
ship to break.
>Our concern is how can we avoid growing log file while
DBREINDEX or
>INDEXDEFRAG running?
>Your response is appreciated.
>Thanks,
>Abbas
>
>.
>|||*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||You can't. These actions, like all in the server are logged. These type of
actions will send a lot of data to the log files. I suggest doing them in
small batches so the logs can recover in between the reindexing. If done
often or there is little fragmentation INDEXDEFRAGmay produce less log
entries.
--
Andrew J. Kelly
SQL Server MVP
"Moh Abb" <mabbas@.aligntech.com> wrote in message
news:%23kkvKL%23cDHA.1828@.TK2MSFTNGP10.phx.gbl...
> We have SQL 2K Enterprise Edition with SP3. Server is dedicated database
> server used for JDE application. Database size is 100 Gig. This DB is
> configured for replication (only 25 tables). This database is also
> configured for Log ship to a stand by server where we run our reports.
> When we run DBCC DBREINDEX or DBCC INDEXDEFRAG on this database, the log
> file start growing crazy, which makes replication and log ship to break.
> Our concern is how can we avoid growing log file while DBREINDEX or
> INDEXDEFRAG running?
> Your response is appreciated.
> Thanks,
> Abbas
>
>|||Hello
You can't avoid this, but you can accommodate yourself to this :-)
I'm using the system of two connected jobs. One of them runs
DBCC INDEXDEFRAG and second periodically (every minute)
checks log state and stops first job when log have more than 70%
of space filled. And the system waits for the next log backup and
starts again. In general controlling job can start log backup instead
of stopping defragmentation.
> When we run DBCC DBREINDEX or DBCC INDEXDEFRAG on this database, the log
> file start growing crazy, which makes replication and log ship to break.
> Our concern is how can we avoid growing log file while DBREINDEX or
> INDEXDEFRAG running?
Serge Shakhovsql

Log in problem

I am using SQL 2000 developer edition and all has been
working fine, until today. In Entrprise manager I can
not log into my local database however I can log into a
remote one. Additionally my local development
applications can access data and function fine they all
use SQL server authentaction.
In enterprise manager whenI try to log in I get the
following message-
Log In Filed for user "name"
please verify your SQL Server is running and check ....
I am sure you all get the idea.
I have tried everything and changed nothing, particularly
any passwords.
Any ideas?
Don
Open Enterprise Manager and right click on the server node.
Select Edit SQL Server Registration Properties. From here,
make sure to enter the correct SQL login and password.
You may also just be experiencing a login time...it's hard
to say without the exact error message. If this is the case,
in Enterprise Manager go to the menu to tools...options. On
the Advanced tab, increase the login timeout from the
default 4 secs to something higher...try 15 to start with.
-Sue
On Mon, 2 Aug 2004 11:54:07 -0700, "Don" <dstull1@.msn.com>
wrote:

>I am using SQL 2000 developer edition and all has been
>working fine, until today. In Entrprise manager I can
>not log into my local database however I can log into a
>remote one. Additionally my local development
>applications can access data and function fine they all
>use SQL server authentaction.
>In enterprise manager whenI try to log in I get the
>following message-
>Log In Filed for user "name"
>please verify your SQL Server is running and check ....
>I am sure you all get the idea.
>I have tried everything and changed nothing, particularly
>any passwords.
>Any ideas?
>Don

Monday, March 26, 2012

log files

I'm using SQL Server 2005 Developer Edition and doing mass data insertion. In
order to optimize for speed, I set the database recovery mode to Simple, both
on my user DB and tempdb in order to avoid huge log files.
(1) why does my tempdb log file still grow large (10 GB) ?
(2) why can't I specify "unrestricted growth" on additional log files for
tempdb? (every time I specify a location with ample HD space for an
additional tempdb log file in the DB Properties, the server sets Autogrowth
to a restricted growth and my changes don't take effect)Can you elaborate on exactly how you are doing these mass insertions?
--
Andrew J. Kelly SQL MVP
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:F538B5DA-328E-489C-AF6A-FA14658010EC@.microsoft.com...
> I'm using SQL Server 2005 Developer Edition and doing mass data insertion.
> In
> order to optimize for speed, I set the database recovery mode to Simple,
> both
> on my user DB and tempdb in order to avoid huge log files.
> (1) why does my tempdb log file still grow large (10 GB) ?
> (2) why can't I specify "unrestricted growth" on additional log files for
> tempdb? (every time I specify a location with ample HD space for an
> additional tempdb log file in the DB Properties, the server sets
> Autogrowth
> to a restricted growth and my changes don't take effect)|||> (2) why can't I specify "unrestricted growth" on additional log files for
> tempdb? (every time I specify a location with ample HD space for an
> additional tempdb log file in the DB Properties, the server sets Autogrowth
> to a restricted growth and my changes don't take effect)
What max size are the files set to?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:F538B5DA-328E-489C-AF6A-FA14658010EC@.microsoft.com...
> I'm using SQL Server 2005 Developer Edition and doing mass data insertion. In
> order to optimize for speed, I set the database recovery mode to Simple, both
> on my user DB and tempdb in order to avoid huge log files.
> (1) why does my tempdb log file still grow large (10 GB) ?
> (2) why can't I specify "unrestricted growth" on additional log files for
> tempdb? (every time I specify a location with ample HD space for an
> additional tempdb log file in the DB Properties, the server sets Autogrowth
> to a restricted growth and my changes don't take effect)|||The raw data is in text files. I created a SSIS package in Management Studio
using the DTS-like import/export tool that reads the file and fills a table
in tempdb. Every time I read in a new table, the SSIS package drops and
re-creates the existing table in tempdb.
"Andrew J. Kelly" wrote:
> Can you elaborate on exactly how you are doing these mass insertions?
> --
> Andrew J. Kelly SQL MVP
>
> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
> news:F538B5DA-328E-489C-AF6A-FA14658010EC@.microsoft.com...
> > I'm using SQL Server 2005 Developer Edition and doing mass data insertion.
> > In
> > order to optimize for speed, I set the database recovery mode to Simple,
> > both
> > on my user DB and tempdb in order to avoid huge log files.
> >
> > (1) why does my tempdb log file still grow large (10 GB) ?
> > (2) why can't I specify "unrestricted growth" on additional log files for
> > tempdb? (every time I specify a location with ample HD space for an
> > additional tempdb log file in the DB Properties, the server sets
> > Autogrowth
> > to a restricted growth and my changes don't take effect)
>
>|||The default for log files was 100MB, I think... But since I could not set it
to "unrestricted growth", I simply changed the max size to 20GB to make sure
I never run out of space.
"Tibor Karaszi" wrote:
> > (2) why can't I specify "unrestricted growth" on additional log files for
> > tempdb? (every time I specify a location with ample HD space for an
> > additional tempdb log file in the DB Properties, the server sets Autogrowth
> > to a restricted growth and my changes don't take effect)
> What max size are the files set to?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
> news:F538B5DA-328E-489C-AF6A-FA14658010EC@.microsoft.com...
> > I'm using SQL Server 2005 Developer Edition and doing mass data insertion. In
> > order to optimize for speed, I set the database recovery mode to Simple, both
> > on my user DB and tempdb in order to avoid huge log files.
> >
> > (1) why does my tempdb log file still grow large (10 GB) ?
> > (2) why can't I specify "unrestricted growth" on additional log files for
> > tempdb? (every time I specify a location with ample HD space for an
> > additional tempdb log file in the DB Properties, the server sets Autogrowth
> > to a restricted growth and my changes don't take effect)
>|||Reason I asked is that when you set to unlimited, SQL Server will actually store and show the
maximum size for a log file (which is 2TB). This is, of course the same as unlimited (as any
database file cannot grow beyond the max specification) but the presentation might confuse a bit. So
if you set to maxsize and it show 2TB, all is fine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:43C1914A-DFA4-4B92-B1E2-FF1E4F30DA11@.microsoft.com...
> The default for log files was 100MB, I think... But since I could not set it
> to "unrestricted growth", I simply changed the max size to 20GB to make sure
> I never run out of space.
> "Tibor Karaszi" wrote:
>> > (2) why can't I specify "unrestricted growth" on additional log files for
>> > tempdb? (every time I specify a location with ample HD space for an
>> > additional tempdb log file in the DB Properties, the server sets Autogrowth
>> > to a restricted growth and my changes don't take effect)
>> What max size are the files set to?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
>> news:F538B5DA-328E-489C-AF6A-FA14658010EC@.microsoft.com...
>> > I'm using SQL Server 2005 Developer Edition and doing mass data insertion. In
>> > order to optimize for speed, I set the database recovery mode to Simple, both
>> > on my user DB and tempdb in order to avoid huge log files.
>> >
>> > (1) why does my tempdb log file still grow large (10 GB) ?
>> > (2) why can't I specify "unrestricted growth" on additional log files for
>> > tempdb? (every time I specify a location with ample HD space for an
>> > additional tempdb log file in the DB Properties, the server sets Autogrowth
>> > to a restricted growth and my changes don't take effect)
>>|||Will SQL delete the table in TEMPDB when it get restarted? Would it be
easier just to create a blank database and store data there?
James
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%239%232RJQIGHA.2628@.TK2MSFTNGP15.phx.gbl...
> Reason I asked is that when you set to unlimited, SQL Server will actually
> store and show the maximum size for a log file (which is 2TB). This is, of
> course the same as unlimited (as any database file cannot grow beyond the
> max specification) but the presentation might confuse a bit. So if you set
> to maxsize and it show 2TB, all is fine.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
> news:43C1914A-DFA4-4B92-B1E2-FF1E4F30DA11@.microsoft.com...
>> The default for log files was 100MB, I think... But since I could not set
>> it
>> to "unrestricted growth", I simply changed the max size to 20GB to make
>> sure
>> I never run out of space.
>> "Tibor Karaszi" wrote:
>> > (2) why can't I specify "unrestricted growth" on additional log files
>> > for
>> > tempdb? (every time I specify a location with ample HD space for an
>> > additional tempdb log file in the DB Properties, the server sets
>> > Autogrowth
>> > to a restricted growth and my changes don't take effect)
>> What max size are the files set to?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
>> news:F538B5DA-328E-489C-AF6A-FA14658010EC@.microsoft.com...
>> > I'm using SQL Server 2005 Developer Edition and doing mass data
>> > insertion. In
>> > order to optimize for speed, I set the database recovery mode to
>> > Simple, both
>> > on my user DB and tempdb in order to avoid huge log files.
>> >
>> > (1) why does my tempdb log file still grow large (10 GB) ?
>> > (2) why can't I specify "unrestricted growth" on additional log files
>> > for
>> > tempdb? (every time I specify a location with ample HD space for an
>> > additional tempdb log file in the DB Properties, the server sets
>> > Autogrowth
>> > to a restricted growth and my changes don't take effect)
>>
>|||Sorry, but I didn't follow the other threads of this discussion, so I don't know that table you are
referring to...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"James" <hushdontspamme@.hotmail.com> wrote in message
news:%236HH2kQIGHA.1192@.TK2MSFTNGP11.phx.gbl...
> Will SQL delete the table in TEMPDB when it get restarted? Would it be easier just to create a
> blank database and store data there?
> James
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%239%232RJQIGHA.2628@.TK2MSFTNGP15.phx.gbl...
>> Reason I asked is that when you set to unlimited, SQL Server will actually store and show the
>> maximum size for a log file (which is 2TB). This is, of course the same as unlimited (as any
>> database file cannot grow beyond the max specification) but the presentation might confuse a bit.
>> So if you set to maxsize and it show 2TB, all is fine.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
>> news:43C1914A-DFA4-4B92-B1E2-FF1E4F30DA11@.microsoft.com...
>> The default for log files was 100MB, I think... But since I could not set it
>> to "unrestricted growth", I simply changed the max size to 20GB to make sure
>> I never run out of space.
>> "Tibor Karaszi" wrote:
>> > (2) why can't I specify "unrestricted growth" on additional log files for
>> > tempdb? (every time I specify a location with ample HD space for an
>> > additional tempdb log file in the DB Properties, the server sets Autogrowth
>> > to a restricted growth and my changes don't take effect)
>> What max size are the files set to?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
>> news:F538B5DA-328E-489C-AF6A-FA14658010EC@.microsoft.com...
>> > I'm using SQL Server 2005 Developer Edition and doing mass data insertion. In
>> > order to optimize for speed, I set the database recovery mode to Simple, both
>> > on my user DB and tempdb in order to avoid huge log files.
>> >
>> > (1) why does my tempdb log file still grow large (10 GB) ?
>> > (2) why can't I specify "unrestricted growth" on additional log files for
>> > tempdb? (every time I specify a location with ample HD space for an
>> > additional tempdb log file in the DB Properties, the server sets Autogrowth
>> > to a restricted growth and my changes don't take effect)
>>
>|||Perhaps I should add: Tempdb is re-created every time SQL Server starts.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"James" <hushdontspamme@.hotmail.com> wrote in message
news:%236HH2kQIGHA.1192@.TK2MSFTNGP11.phx.gbl...
> Will SQL delete the table in TEMPDB when it get restarted? Would it be easier just to create a
> blank database and store data there?
> James
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%239%232RJQIGHA.2628@.TK2MSFTNGP15.phx.gbl...
>> Reason I asked is that when you set to unlimited, SQL Server will actually store and show the
>> maximum size for a log file (which is 2TB). This is, of course the same as unlimited (as any
>> database file cannot grow beyond the max specification) but the presentation might confuse a bit.
>> So if you set to maxsize and it show 2TB, all is fine.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
>> news:43C1914A-DFA4-4B92-B1E2-FF1E4F30DA11@.microsoft.com...
>> The default for log files was 100MB, I think... But since I could not set it
>> to "unrestricted growth", I simply changed the max size to 20GB to make sure
>> I never run out of space.
>> "Tibor Karaszi" wrote:
>> > (2) why can't I specify "unrestricted growth" on additional log files for
>> > tempdb? (every time I specify a location with ample HD space for an
>> > additional tempdb log file in the DB Properties, the server sets Autogrowth
>> > to a restricted growth and my changes don't take effect)
>> What max size are the files set to?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
>> news:F538B5DA-328E-489C-AF6A-FA14658010EC@.microsoft.com...
>> > I'm using SQL Server 2005 Developer Edition and doing mass data insertion. In
>> > order to optimize for speed, I set the database recovery mode to Simple, both
>> > on my user DB and tempdb in order to avoid huge log files.
>> >
>> > (1) why does my tempdb log file still grow large (10 GB) ?
>> > (2) why can't I specify "unrestricted growth" on additional log files for
>> > tempdb? (every time I specify a location with ample HD space for an
>> > additional tempdb log file in the DB Properties, the server sets Autogrowth
>> > to a restricted growth and my changes don't take effect)
>>
>sql

log files

Friday, March 9, 2012

Log File

We are running SQL 2000 Enterprise Edition. How do I setup the log file to
go to a different partition? Thanks.
Take a look at sp_attach_db and sp_detach_db in BooksOnLine.
Andrew J. Kelly SQL MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> We are running SQL 2000 Enterprise Edition. How do I setup the log file
to
> go to a different partition? Thanks.
>
|||Hi,
Login to SQL server using Query Analyzer:-
sp_detach_db <dbname>
-- this will detach the database from sql server, so move the LDF file to
new location using windows explorer. After this execute
sp_atatch_db <dbname>,'MDF_file_wth_path','LDF_file_with_NEW_pa th'
Thanks
Hari
MCDBA
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> We are running SQL 2000 Enterprise Edition. How do I setup the log file
to
> go to a different partition? Thanks.
>
|||Thank you. I'll give it a try.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23C0$0vIZEHA.2408@.tk2msftngp13.phx.gbl...
> Hi,
> Login to SQL server using Query Analyzer:-
> sp_detach_db <dbname>
> -- this will detach the database from sql server, so move the LDF file to
> new location using windows explorer. After this execute
> sp_atatch_db <dbname>,'MDF_file_wth_path','LDF_file_with_NEW_pa th'
>
> Thanks
> Hari
> MCDBA
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> to
>
|||Thank you. I'll give it a try.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OGWEeCIZEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Take a look at sp_attach_db and sp_detach_db in BooksOnLine.
> --
> Andrew J. Kelly SQL MVP
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> to
>

Log File

We are running SQL 2000 Enterprise Edition. How do I setup the log file to
go to a different partition? Thanks.Take a look at sp_attach_db and sp_detach_db in BooksOnLine.
--
Andrew J. Kelly SQL MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> We are running SQL 2000 Enterprise Edition. How do I setup the log file
to
> go to a different partition? Thanks.
>|||Hi,
Login to SQL server using Query Analyzer:-
sp_detach_db <dbname>
-- this will detach the database from sql server, so move the LDF file to
new location using windows explorer. After this execute
sp_atatch_db <dbname>,'MDF_file_wth_path','LDF_file_with_NEW_path'
Thanks
Hari
MCDBA
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> We are running SQL 2000 Enterprise Edition. How do I setup the log file
to
> go to a different partition? Thanks.
>|||Thank you. I'll give it a try.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23C0$0vIZEHA.2408@.tk2msftngp13.phx.gbl...
> Hi,
> Login to SQL server using Query Analyzer:-
> sp_detach_db <dbname>
> -- this will detach the database from sql server, so move the LDF file to
> new location using windows explorer. After this execute
> sp_atatch_db <dbname>,'MDF_file_wth_path','LDF_file_with_NEW_path'
>
> Thanks
> Hari
> MCDBA
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> > We are running SQL 2000 Enterprise Edition. How do I setup the log file
> to
> > go to a different partition? Thanks.
> >
> >
>|||Thank you. I'll give it a try.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OGWEeCIZEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Take a look at sp_attach_db and sp_detach_db in BooksOnLine.
> --
> Andrew J. Kelly SQL MVP
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> > We are running SQL 2000 Enterprise Edition. How do I setup the log file
> to
> > go to a different partition? Thanks.
> >
> >
>

Log File

We are running SQL 2000 Enterprise Edition. How do I setup the log file to
go to a different partition? Thanks.Take a look at sp_attach_db and sp_detach_db in BooksOnLine.
Andrew J. Kelly SQL MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> We are running SQL 2000 Enterprise Edition. How do I setup the log file
to
> go to a different partition? Thanks.
>|||Hi,
Login to SQL server using Query Analyzer:-
sp_detach_db <dbname>
-- this will detach the database from sql server, so move the LDF file to
new location using windows explorer. After this execute
sp_atatch_db <dbname> ,'MDF_file_wth_path','LDF_file_with_NEW_
path'
Thanks
Hari
MCDBA
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> We are running SQL 2000 Enterprise Edition. How do I setup the log file
to
> go to a different partition? Thanks.
>|||Thank you. I'll give it a try.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23C0$0vIZEHA.2408@.tk2msftngp13.phx.gbl...
> Hi,
> Login to SQL server using Query Analyzer:-
> sp_detach_db <dbname>
> -- this will detach the database from sql server, so move the LDF file to
> new location using windows explorer. After this execute
> sp_atatch_db <dbname> ,'MDF_file_wth_path','LDF_file_with_NEW_
path'
>
> Thanks
> Hari
> MCDBA
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> to
>|||Thank you. I'll give it a try.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OGWEeCIZEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Take a look at sp_attach_db and sp_detach_db in BooksOnLine.
> --
> Andrew J. Kelly SQL MVP
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ea$DRjGZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> to
>

Friday, March 30, 2012

Log is growing crazy when run DBCC INDEXDEFRAG or DBREINDEX

Log in problem

Monday, March 26, 2012

log files

log files

log files

Friday, March 9, 2012

Log File

Log File

Log File

Locks and Blocks

Blog Archive

About Me