SQL Server 2008 R2 Express
Questions Regarding: SQL Server 2008 R2 Express
Kindly highlight the limitations of the above Microsoft SQL product - Pls provide this in simple learner terms.
How can we easily determine the size of databases?
What happens when the limit of this has been reached?
What symptom should we be aware of?
Kindly highlight the limitations of the above Microsoft SQL product - Pls provide this in simple learner terms.
How can we easily determine the size of databases?
What happens when the limit of this has been reached?
What symptom should we be aware of?
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
tx jonnidip
I'm not familiar with SQL Server operations.
How would I execute above please?
I'm not familiar with SQL Server operations.
How would I execute above please?
ASKER
Can you explain under Database mirroring what is mean't by "Witness only" in
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx
Practically, can I mirror an SQL Server 2008 R2 Express and how?
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx
Practically, can I mirror an SQL Server 2008 R2 Express and how?
How would I execute above please?
Start SSMS. File New Query. Paste the SQL script with the correct database name. Press F5
Can you explain under Database mirroring what is mean't by "Witness only"
I suggest you read up on it here Database Mirroring Overview
Start SSMS. File New Query. Paste the SQL script with the correct database name. Press F5
Can you explain under Database mirroring what is mean't by "Witness only"
I suggest you read up on it here Database Mirroring Overview
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Tx.
Is there a graphical interface that can achieve this, for the novice SQL Server User please?
This is to know the size of the db:
use myDatabaseName
exec sp_spaceused
How would I execute above please?
Start SSMS. File New Query. Paste the SQL script with the correct database name. Press F5
Is there a graphical interface that can achieve this, for the novice SQL Server User please?
This is to know the size of the db:
use myDatabaseName
exec sp_spaceused
How would I execute above please?
Start SSMS. File New Query. Paste the SQL script with the correct database name. Press F5
If you right click on the database and the select Reports > Standard Reports. There is a whole list of different reports the you can generate.
ASKER
tx. Getting attached error when run Disk Size Report'any ideas please?
I didn't see a report for RAM utilization - there is a 1Gig limit.
How can I ascertain this usage please?
CaptureDS.JPG
I didn't see a report for RAM utilization - there is a 1Gig limit.
How can I ascertain this usage please?
CaptureDS.JPG
Is your database running on a SQL 2005 instance or at the correct compatibility level?
ASKER
Pls see how I connect. - clear 2008 R2.
However not sure why there are 2 identical option to connect to?
How can I check the compatibility level please?
CaptureDS1.JPG
However not sure why there are 2 identical option to connect to?
How can I check the compatibility level please?
CaptureDS1.JPG
SELECT name,compatibility_level from sys.databases80 - SQL 2000
90 - SQL 2005
100 - SQL 2008 & 2008 R2
110 - SQL 2012
Open in new window
When you reach the db size limit you should get an error message like this:
Could not allocate space for object 'dbo.[table]' in database '[database]' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup.
This will disable the use of "INSERT", while still let you do "SELECT, DELETE, UPDATE".
Regards.