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 |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
 Posted - 2008-07-25 : 11:59:12
|
| Just curious. What is the SQL Server version/edition this site runs on? How big is the database?CODO ERGO SUM |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-07-25 : 12:29:06
|
| I thought this ran on Lotus Notes?;)e4 d5 xd5 Nf6 |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-25 : 12:43:33
|
| sql 2005 express edition.the db size is 1.5 gb i think._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2008-07-25 : 12:52:28
|
| We do run on SQL Server Express. The main database that holds the forums and articles is about 1.1 GB. There are also databases for the newsletter, advertising and the blogs. The blogs database is actually bigger than the main database. Mostly because they store every URL the site ever sees -- including the spammy URLs. I need to write a script to go clear those out one of these days.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-07-25 : 14:22:40
|
quote:
Originally posted by grazWe do run on SQL Server Express...
How do you run database backups without SQL Agent?CODO ERGO SUM |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2008-07-25 : 15:13:00
|
| OrcsWeb has a script they run that backs up the databases and copies them up to their server.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-03 : 04:19:03
|
Or see Spirit's two articles about mimicing the SQL Agent with Service Broker?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2008-12-04 : 09:00:34
|
| Yeah, I saw those :) I think as long as Orcsweb is providing the script and it's working I'm just going to leave it running.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
|
|
|
Forum Facts