Viewing 15 posts - 31,246 through 31,260 (of 49,552 total)
JKSQL (8/13/2010)
Is there anyway to create a DB on 2008 and still be able to restore it to a 2005 engine.
No. None whatsoever. There's no downgrade ability for SQL databases.
Export...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2010 at 3:25 am
JKSQL (8/13/2010)
The compatibility is set to SQL Server 2005 (90). That is why I thought the .bak would be formatted correctly using the backup utility from SQL 2008 R2.
The...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 11:31 am
fawwad (8/13/2010)
dont you think we should archive our database after ARCHIVING activity ??
Depends. How much are you archiving? How much space is free after? How long will it take new...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 10:29 am
It's got nothing to do with the version of SSMS. It's got to do with the version of SQL Server engine.
I regularly take backups of my 2005 databases using SSMS...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 9:52 am
If a drive is not a cluster resource and a dependency of the SQL service, SQL cannot even see that drive. Hence if you do an ALTER DATABASE and set...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 9:49 am
Please post new questions in a new thread. Thank you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 9:40 am
I think this is another case where task manager is wrong (for whatever reason). Look at those perfmon counters. Total server memory (amount of memory currently used) is 11GB, not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 9:36 am
Can you configure direct attached drives as cluster resources? A clustered SQL Server can only use drives that are configured as cluster resources and are dependencies of the SQL service.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 9:23 am
Alan Spillert (8/13/2010)
Task Manager now shows Peak Mem Usage of 4,194,303;
Rather than using task manager, can you use perfmon and check the Total Server memory counter? (under SQL Server:Memory...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 8:46 am
Log shipping once a day means that you can lose up to a full day of data in the case of a server failure. Is that acceptable to your users?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 8:40 am
Alan Spillert (8/13/2010)
After posting I changed the server memory max and min to 16384 and 20480 respectively
I hope you mean the other way around. Min should be lower than max.
The...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 8:38 am
David Benoit (8/13/2010)
GilaMonster (8/13/2010)
4GB is the maximum amount of memory a 32 bit app can use running on a 64 bit OS.
Thanks Gail. Hate to think that this is what...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 6:56 am
David Benoit (8/13/2010)
Out of curiosity what makes you think this is a WOW configuration even though he stated that both Windows and SQL Server were 64-Bit?
4GB is the maximum...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 6:40 am
1000
That's no more than an educated estimate of the point where fragmentation will start to have a noticeable effect on range scans from disk. It is not the point where...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 6:34 am
MSSQLBuddy (8/13/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2010 at 5:55 am
Viewing 15 posts - 31,246 through 31,260 (of 49,552 total)