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 |
|
pearsont74
Starting Member
27 Posts |
 Posted - 2007-06-20 : 11:08:10
|
| ok...i do a data load into 3 sql servers (dev, edi production and web production)same data on all 3...the only difference is the web server has webpages running.heres my problem - the load on dev and edi production runs finethe web is a different story....ineed to know how i can check sql and prevent any locks or accessing the database im loading into while im loading...cause i have lag and no responces when i do the dts or the import wizard...heres the steps i take to load new data - drop indexestruncate tables im loading new data into(i started running a db shrink that decreases teh size,works great on the other 2 sql servers.)run the dts package (access to sql) straight import reindexbackup dbim i missing anything - should i take a different approach?? help...im sick of stayin up all night due to this |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-20 : 11:49:01
|
| You can set the database to admin only to do the load.You could split the database into two - one which the you refresh and one which you don't. Presumably the one you are updating is read only for the web site.Now have another identical database which you load into. Now nothing will access this while you load - when complete rename the databases.You could also access this new database via views from the old (means no change to anything else). Now the swap becomes a matter of changing all the views to point at the newly refreshed database (and recompiling all the queries).==========================================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. |
 |
|
|
pearsont74
Starting Member
27 Posts |
Posted - 2007-06-20 : 13:09:01
|
| i wasnt aware you can rename a db?as far as the admin only....do i jsut set the access to the other users to view?i still do not see why it takes alot longer on the webserver vs the other 2....server wise...theres slight difference but not alot. |
|
|
|
|
|
|
Import same dataset over 3 sql servers