Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spirit1
Cybernetic Yak Master
11752 Posts |
 Posted - 2004-11-24 : 11:57:20
|
hi all!i never done much administration of servers so now i decided to do some.so the first thing i'd like to do (in contrary to everyone else  )is to set my test db to perform no back up at all.so if i insert, update or delete records no log is done.there are backup, restore and all that but that's not what i want.how do i do that???Go with the flow & have fun! Else fight the flow  |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-24 : 12:50:06
|
| Find out how it is being backed up and disable it.It is probably a scheduled job but may be a 3rd party tool.Note if you are rtying to test tr log growth you need to do a full backup otherwise the log will be truncated as the tr log is no use without a full backup.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-24 : 12:58:34
|
| well this is the thing:i used northwind to create a new tableand inserted 1.000.000 rows into it.i watched northwnd.ldf (that's the log right?) file and it grew a few 100 Mb.i want it not to grow... how do i disable that.yeah i'm probably confusing backups with tran logs growth...Go with the flow & have fun! Else fight the flow |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-24 : 13:13:33
|
| Seehttp://www.nigelrivett.net/TransactionLogFileGrows_1.htmlSet the recovery model to simple is probably the best you can do to stop it growing.This will not affect a single statement (or if you have open transactions). To do that you will need to split the statement into batches - do a truncate log or checkpoint between each one if necessary.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-24 : 13:29:33
|
| aha great reading BTW, thanx.so i guess sql server was just doing it thing in the right way.i used DBCC SHRINKDATABASE ('Northwind', 10) instead of DBCC SHRINKFILErecovery model was set to simple.thanx.Go with the flow & have fun! Else fight the flow |
|
|
|
|
|
|
set no back up