Viewing 15 posts - 42,346 through 42,360 (of 49,552 total)
james.ellingworth (12/16/2008)
Thank you GilaMonster for your advice. As I said in my other post, I only realised that the DTS Section existed at a later stage.
If you repost in...
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
December 16, 2008 at 3:24 am
Is this a homework assignment?
Can you post the schema as it is now?
The quiz table as you describe it is in violation of 1st normal form. It has repeating groups....
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
December 16, 2008 at 1:44 am
Not exacly, but they're very different from restoring user databases. Books Online has a good section on restoring the various system databases.
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
December 16, 2008 at 1:41 am
Is the database online?
Can you try and run a backup from the query window -
BACKUP DATABASE Emp TO DISK = ' Full path to backup file here '
If...
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
December 16, 2008 at 12:31 am
Saurabh Vegda (12/16/2008)
Yes, it seems to have been pulled out, strange...:(
I'll see if I can get an explanation from someone for the pull back and when it'll be available again.
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
December 16, 2008 at 12:29 am
It says that a deadlock occurred and this process (whatever it is) was the deadlock victim and hence it was killed.
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
December 16, 2008 at 12:20 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic615879-19-1.aspx
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
December 16, 2008 at 12:18 am
ps (12/16/2008)
You need to backup master and msdb databases besides user databases.
And model if you've made any changes to that.
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
December 16, 2008 at 12:16 am
Saurabh Vegda (12/15/2008)
http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en
We are sorry, the page you requested cannot be found.
Looks like it's been pulled back for some reason...
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
December 16, 2008 at 12:06 am
Jack Corbett (12/15/2008)
Maybe one of you guys has the answer they want.
Why not. I've only had one twit so far this week. I don't have the answer he wants,...
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
December 15, 2008 at 2:53 pm
metro17 (12/15/2008)
Thanks..But the issue is I would like to track the changes that have already been done .
Can't be done.
SQL doesn't keep track of that information unless you 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
December 15, 2008 at 2:51 pm
Jpotucek (12/15/2008)
What - if any - damage could I cause if I dropped the non-unique - non-clusered index and left the clustered/unique PK index???
There shouldn't be any damage
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
December 15, 2008 at 1:55 pm
Ok...... Never seen that before.
If it's stack dumping, you need to call customer support.
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
December 15, 2008 at 1:47 pm
dbdbdb (12/15/2008)
Let me clarify my certification goals at this point:MCITP: Database Administrator 2008
MCITP: Database Developer 2008
MCITP: Business Intelligence Development and Maintenance 2008
Do you do dev, admin and BI?
Now as I...
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
December 15, 2008 at 1:42 pm
By unrecoverable, do you mean the deadlock detector's not picking it up? Does having traceflag 1222 on result in a deadlock graph in the error log?
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
December 15, 2008 at 1:36 pm
Viewing 15 posts - 42,346 through 42,360 (of 49,552 total)