Viewing 15 posts - 36,331 through 36,345 (of 49,552 total)
tvanharp (10/12/2009)
I found that I can't restore the backup created with the copy only clause in mgnt studio.
Known bug. Can't recall if there's a connect item opened for it...
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
October 13, 2009 at 1:17 am
Joseph Fallon (10/12/2009)
The SQL Service user is in the Admin group on the server so should have ample rights ?
Not necessarily. It's possible to deny to an administrator
@Jeffrey I'll try...
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
October 13, 2009 at 1:15 am
gking-756277 (10/12/2009)
I installed SQL Server 2008 and BIDS.
So you have not purchased and installed Visual Studio?
BIDS is only the business intelligence projects. Unless you have also purchased and installed...
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
October 12, 2009 at 12:37 pm
Did you install Visual Studio 2008, or did you install BIDS from the SQL installer?
If you just installed BIDS, there's no C# projects included.
If you have full-blown visual studio...
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
October 12, 2009 at 11:59 am
Assuming that this is a clustered SQL Server....
The drives have to be added as a dependency to SQL. This is done in cluster administration.
Ask the server admin (assuming he...
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
October 12, 2009 at 11:08 am
Krasavita (10/12/2009)
What is your suggestion? Thank you
GilaMonster (10/12/2009)
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
October 12, 2009 at 10:59 am
Bob Hovious 24601 (10/12/2009)
Adding "urgent" or "please help me" strikes me as being fairly immature, which leads me to believe that they are issues related to homework assignments.
Or a project...
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
October 12, 2009 at 10:59 am
First read this http://www.sqlservercentral.com/articles/65804/
Once you have read that...
Run the following and post the full output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a backup from before running repair?...
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
October 12, 2009 at 10:42 am
tvanharp (10/12/2009)
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
October 12, 2009 at 10:42 am
You need to use dynamic SQL here.
Extract of code that needs to change
...
SET @sSQL = 'ALTER INDEX [' + @ndxnm + '] ON [' + @tblnm + '] REBUILD PARTITION...
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
October 12, 2009 at 10:38 am
Silverfox (10/12/2009)
Bob Hovious 24601 (10/12/2009)
Because his homework assignment is due in the morning?LOL, do you have something against software engineers 😛
Only lazy ones.
p.s. I was a software developer, I still...
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
October 12, 2009 at 10:33 am
Krasavita (10/12/2009)
What do you mean...
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
October 12, 2009 at 10:32 am
Why are you casting to varchar in the first place if you're going to match the values too another table?
This is very urgent? Why?
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
October 12, 2009 at 6:24 am
p.s. you are trying to attach them back to the SQL 2008 instance?
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
October 12, 2009 at 6:22 am
Beginer (10/11/2009)
As per my understannding the autocheckpoint should happen when the log file becomes 70% full.
No, that's for TempDB. For user databases it runs regularly to keep the expected recovery...
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
October 12, 2009 at 6:20 am
Viewing 15 posts - 36,331 through 36,345 (of 49,552 total)