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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How do i Load database server

Author  Topic 

vivekshah
Starting Member

1 Post

Posted - 2006-05-31 : 01:21:02

Hello friends

Is there any method/solution so that i can externally load the databse.

I need it for the project i am currently working on.
it comprises of some online restaurant, that has one central database server & all the restaurant acces this server for evry single request they fire.

BUT during weekends the server has tremendous load.

So any idea how do i load the database server?
any query/procedure or any idea?

Thanx in advance



Vivek

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-05-31 : 01:39:20
what do you mean by load?
attach it to the server or restore a backup file?



--------------------
keeping it simple...
Go to Top of Page

mr_mist
Grunnio

1870 Posts

Posted - 2006-05-31 : 04:52:31
By load do you mean "put lots of sample usage on?"

There's a stress tool that Microsoft had a while ago.

-------
Moo. :)
Go to Top of Page

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2006-06-01 : 13:47:47
check out http://support.microsoft.com/kb/q231619/
Go to Top of Page
   

- Advertisement -