Viewing 15 posts - 42,361 through 42,375 (of 49,571 total)
Amit Garg (5/12/2006)
December 16, 2008 at 4:47 am
suresh.maddali (12/16/2008)
I am NEW FOR DBA Please how do i know which files or filegroups are in online?
No need to repeat yourself... Is there a senior DBA there?
Query sys.database_files for...
December 16, 2008 at 4:40 am
It's back. No explanation though. Maybe when the guys in Redmond wake up.
December 16, 2008 at 4:10 am
suresh.maddali (12/16/2008)
yes database is online....
Are all the filegroups in the database online and readable?
December 16, 2008 at 3:26 am
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...
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....
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.
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...
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.
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.
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
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.
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...
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,...
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...
December 15, 2008 at 2:51 pm
Viewing 15 posts - 42,361 through 42,375 (of 49,571 total)