Has anyone had timeout problems when backup up an Express database?

I was always able to backup until my data went over approximately 500 meg. Now when the backup is running it times out. I checked the Express settings and all timeout parameters are set at 60 seconds. But the backup times out at about 30 seconds.

The message is

TITLE: Microsoft SQL Server Management Studio Express

Backup failed for Server 'MYEXP\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

Hey Expressman,

Since you're doing your backup using Management Studio Express, I'm going to move this thread over to the Tools forum where SSMSE questions are answered.

- Mike

Hardware sizing documentation?

I am running an SAP system with approximately 250 users (150-170
concurrent). The database is currently around 200Gb in size, running on SQL
2000 standard edition and Windows 2000 standard server. The server is a quad
500Mhz Xeon with 4Gb of ram, 1.7Gb assigned to SQL, SAP and OS having whats
left. What I am looking for is a rough guide to how much memory the server
should have in relation to the database size. Anybody know of any good
guides to sizing the server hardware? (I realise that to use over 2Gb I need
different versions of SQL and OS)
thanks
GavGav
http://www.sql-server-performance.com/awe_memory.asp
[url]http://www.sql-server-performance.com/performance_monitor_counters_memory.asp[/url
]
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cl80ka$m3s$1@.sparta.btinternet.com...
> I am running an SAP system with approximately 250 users (150-170
> concurrent). The database is currently around 200Gb in size, running on
SQL
> 2000 standard edition and Windows 2000 standard server. The server is a
quad
> 500Mhz Xeon with 4Gb of ram, 1.7Gb assigned to SQL, SAP and OS having
whats
> left. What I am looking for is a rough guide to how much memory the server
> should have in relation to the database size. Anybody know of any good
> guides to sizing the server hardware? (I realise that to use over 2Gb I
need
> different versions of SQL and OS)
> thanks
> Gav
>|||You can also go to HP and IBM websites. They both have sizing tools. You
type in SQL Server, transaction load, write %, size, etc. It recommends a
machine. It's generally pretty accurate, if you're not running anything
wacky.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uJ#ccP1tEHA.904@.TK2MSFTNGP11.phx.gbl...
> Gav
> http://www.sql-server-performance.com/awe_memory.asp
>
http://www.sql-server-performance.c...ters_memory.asp">
> "Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
> news:cl80ka$m3s$1@.sparta.btinternet.com...
> SQL
> quad
> whats
server[vbcol=seagreen]
> need
>

Hardware sizing documentation?

I am running an SAP system with approximately 250 users (150-170
concurrent). The database is currently around 200Gb in size, running on SQL
2000 standard edition and Windows 2000 standard server. The server is a quad
500Mhz Xeon with 4Gb of ram, 1.7Gb assigned to SQL, SAP and OS having whats
left. What I am looking for is a rough guide to how much memory the server
should have in relation to the database size. Anybody know of any good
guides to sizing the server hardware? (I realise that to use over 2Gb I need
different versions of SQL and OS)
thanks
Gav
Gav
http://www.sql-server-performance.com/awe_memory.asp
http://www.sql-server-performance.co...ers_memory.asp
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cl80ka$m3s$1@.sparta.btinternet.com...
> I am running an SAP system with approximately 250 users (150-170
> concurrent). The database is currently around 200Gb in size, running on
SQL
> 2000 standard edition and Windows 2000 standard server. The server is a
quad
> 500Mhz Xeon with 4Gb of ram, 1.7Gb assigned to SQL, SAP and OS having
whats
> left. What I am looking for is a rough guide to how much memory the server
> should have in relation to the database size. Anybody know of any good
> guides to sizing the server hardware? (I realise that to use over 2Gb I
need
> different versions of SQL and OS)
> thanks
> Gav
>
|||You can also go to HP and IBM websites. They both have sizing tools. You
type in SQL Server, transaction load, write %, size, etc. It recommends a
machine. It's generally pretty accurate, if you're not running anything
wacky.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uJ#ccP1tEHA.904@.TK2MSFTNGP11.phx.gbl...
> Gav
> http://www.sql-server-performance.com/awe_memory.asp
>
http://www.sql-server-performance.co...ers_memory.asp[vbcol=seagreen]
> "Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
> news:cl80ka$m3s$1@.sparta.btinternet.com...
> SQL
> quad
> whats
server
> need
>

Hardware sizing documentation?

I am running an SAP system with approximately 250 users (150-170
concurrent). The database is currently around 200Gb in size, running on SQL
2000 standard edition and Windows 2000 standard server. The server is a quad
500Mhz Xeon with 4Gb of ram, 1.7Gb assigned to SQL, SAP and OS having whats
left. What I am looking for is a rough guide to how much memory the server
should have in relation to the database size. Anybody know of any good
guides to sizing the server hardware? (I realise that to use over 2Gb I need
different versions of SQL and OS)
thanks
GavGav
http://www.sql-server-performance.com/awe_memory.asp
http://www.sql-server-performance.com/performance_monitor_counters_memory.asp
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cl80ka$m3s$1@.sparta.btinternet.com...
> I am running an SAP system with approximately 250 users (150-170
> concurrent). The database is currently around 200Gb in size, running on
SQL
> 2000 standard edition and Windows 2000 standard server. The server is a
quad
> 500Mhz Xeon with 4Gb of ram, 1.7Gb assigned to SQL, SAP and OS having
whats
> left. What I am looking for is a rough guide to how much memory the server
> should have in relation to the database size. Anybody know of any good
> guides to sizing the server hardware? (I realise that to use over 2Gb I
need
> different versions of SQL and OS)
> thanks
> Gav
>|||You can also go to HP and IBM websites. They both have sizing tools. You
type in SQL Server, transaction load, write %, size, etc. It recommends a
machine. It's generally pretty accurate, if you're not running anything
wacky.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uJ#ccP1tEHA.904@.TK2MSFTNGP11.phx.gbl...
> Gav
> http://www.sql-server-performance.com/awe_memory.asp
>
http://www.sql-server-performance.com/performance_monitor_counters_memory.asp
> "Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
> news:cl80ka$m3s$1@.sparta.btinternet.com...
> > I am running an SAP system with approximately 250 users (150-170
> > concurrent). The database is currently around 200Gb in size, running on
> SQL
> > 2000 standard edition and Windows 2000 standard server. The server is a
> quad
> > 500Mhz Xeon with 4Gb of ram, 1.7Gb assigned to SQL, SAP and OS having
> whats
> > left. What I am looking for is a rough guide to how much memory the
server
> > should have in relation to the database size. Anybody know of any good
> > guides to sizing the server hardware? (I realise that to use over 2Gb I
> need
> > different versions of SQL and OS)
> >
> > thanks
> >
> > Gav
> >
> >
>