Also, you should now proceed to apply Service Pack 3 for SQL2008

there are no 'errors' in there, you have a working installation. The AWE message is just telling you that you have not enabled SQL to use memory above the 4GB...

this must be a non-clustered index, how much space it will take is dependant on the columns that make up the index, no of rows in the table and padding...

Robert Davis (6/29/2012)

---

george sibbald (6/29/2012)

---

the resource database only changes when you patch SQL server so you only need to make a copy of it then (flat file copy). So do...

the resource database only changes when you patch SQL server so you only need to make a copy of it then (flat file copy). So do this manually at that...

duplicate post, answers to http://www.sqlservercentral.com/Forums/Topic1323159-1550-1.aspx please

Don't know whether the user was added to the db_owner role or made dbo of the database, but either way both events are logged in the default trace.

If the...

Robert.Brown 26968 (6/29/2012)

---

I go this wrong because I answered 1. But that was because if you execute the select statement again by itself, you will get one row returned....

From what you have said so far it sounds like log file bloat is your problem, and in particular this was caused by an index rebuild.

If extra disk space is...

sturner (6/26/2012)

---

archie flockhart (6/26/2012)

---

Or you need to accept that there are some things...

correct

is this the restore of the initial full backup?

sounds like you have a striped backup and you need to supply all the files in the backup set to the restore...

Anthony, is that the same thread I referred to?

http://www.sqlservercentral.com/Forums/Topic1303857-391-2.aspx

I can't see where he says he switched to developer edition from evaluation edition

backup master, msdb and model. Tempdb and resource database cannot be backed up. Tempdb is recreated on server restart so no point even if you could back it up.

Take a...

does the account you are using have sysadmin rights, that right is required.

Another thread on the same issue it turned out to be due to a bad install file, after...