Viewing 15 posts - 46,006 through 46,020 (of 49,552 total)
You need to restore the backup you took before restoring the previous night's backup. Restore that somewhere and interegate the log.
The database that you restored to the previous night's backup...
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
July 2, 2008 at 5:59 am
Are all the files where SQL expects them to be? Query sys.master_files and see where SQL thinks the data files should be. Make sure they are there.
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
July 2, 2008 at 5:54 am
Yes, your're right it should.
I cvan't test now, but I have seen it in the past on a restored database.
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
July 2, 2008 at 5:53 am
I don't know of any functions within SQL to read a backued up transaction log. all the ones (DBCC Log, fn_dblog) read the active portion of the log, not a...
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
July 2, 2008 at 5:27 am
Could you post a particuarly nasty example?
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
July 2, 2008 at 5:25 am
Enbee (7/2/2008)
1. Is there any difference between taking 1 day data and 10 days data from this huge database.
Depends on the indexes that you have.
2. How to know that how...
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
July 2, 2008 at 2:48 am
Steve Jones - Editor (7/1/2008)
What do you mean "write the exam"? That doesn't make sense.
Difference in slang in different places.
Down where I live we use the term "write the exam"...
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
July 2, 2008 at 12:00 am
terry.jago (7/1/2008)
The process for clearing this is as follows
1) dbcc opentran(dbname) - this will show the oldest open transaction
2) Kill this process command kill suid
3) backup...
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
July 1, 2008 at 11:54 pm
kentangki (7/1/2008)
Hi All,i facing almost the same problem, but here i use sql 2000 enterprise with ibm x3650 server.
i use dual core xeon 1.7 gigs with physical memory 4 gigs
Please...
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
July 1, 2008 at 1:25 pm
Peter Curd (7/1/2008)
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
July 1, 2008 at 1:23 pm
Loner (6/26/2008)
Why not shrink the database?
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-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
July 1, 2008 at 12:55 pm
Do you have primary keys (clustered index) on guids? (uniqueidentifier default to NewID())
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
July 1, 2008 at 12:54 pm
I normally call them direct, but then I work for a MS premier customer.
Google gave me the following kb article that should get you started. It will cost you something...
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
July 1, 2008 at 7:26 am
Also, during those slow times, query sysprocesses and look for what the wait times and last wait types are.
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
July 1, 2008 at 7:16 am
Not that I'm aware of.
The power of the machine won't affect the results of the tuning advisor. Only the volumnes of data and the workload trace affect that.
The SQL versions...
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
July 1, 2008 at 7:14 am
Viewing 15 posts - 46,006 through 46,020 (of 49,552 total)