That was my understanding too.

We have a number of filegroups which have an assigned schema against that file group, and we just wanted to have the schemas together on the...

Hi Adiga

No our issue hasnt been resolved as it will require a full rebuild of the virtual server and SQL.

As the server is SQL 2000 we move MSDB and MODEL...

I have already done this.

Both services run as the same account.

Recreated the MAPI profile

All services restarted

Server rebooted

Thanks

Ant

Doug

I was changing the account through services.msc.

I will arrange downtime and change through config manager and repost the results.

Anthony

The issue is not with the master log file, it is with the master data file.

I dont see how moving the log will resolve the issue

Thanks

Ant

thats the thing, there are no errors in the event log of sql log, i am totally baffled to this

database default locations where changed at the time of installation.

D for data

F for logs

G for backups

we have been stopping and starting the SQL services through out the day and all...

The version will have to be enterprise due to the amount of RAM that is being installed into each machine.

As per proc vs cals we have approx 1000 users who...

So I take it this means I will have to buy the following

SQL 2008 Enterprise 2 Processor Licence for the SQL server

SQL 2008 Enterprise 2 Processor Licence for the SSIS...

The issue is now resolved, there was a rule blocking the server from connecting to the exchange server.

Our exchange servers are set up for SMTP.

I know the account has an...

The SQL Server can ping the exhcange server and outlook opens on the server with the same profile and pulls back all emails from the exchange server, so connectivity is...

Date20/11/2008 13:22:49

LogDatabase Mail (Database Mail Log)

Log ID2820

Process ID7492

Mail Item ID2701

Last Modified20/11/2008 13:22:49

Last Modified Bysa

Message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail...

Yes I was aware that MS purchased 4.2 off Sybase and rebranded as SQL

The server has a static IP and port specific for its own SQL Server. We have a number of web boxes and other servers which hook into the databases.

It...

The /PAE and /3GB stay in the boot.ini file yes.

The server still shows 16 in the lowest value for max server memory but the maximum shoots back up to the...