Viewing 15 posts - 41,656 through 41,670 (of 49,562 total)
Not a bad question, but does this guy ever read the posts that he's answering?
http://www.sqlservercentral.com/Forums/FindPost638650.aspx
Question was "I didn't start an explicit transaction, I don't have a backup, how do I...
January 17, 2009 at 1:01 am
kiransuram19 (1/16/2009)
(I am confused little bit)..That means when we take a backup it only consider .mdf file size ?
The mdf and enough of the log to be able to restore...
January 17, 2009 at 1:01 am
Paresh Prajapati (1/16/2009)
otherwise if u take transaction log backup..then restore full bakup with norecovery and apply log with recovery..
Except that he said he doesn't have a backup.
January 17, 2009 at 12:51 am
Themis Tokkaris (1/16/2009)
If I create a Database Backup from a SQL Server 2008 Instance, can I restore this backup on a SQL Server 2005 Instance?
No. It is never possible to...
January 16, 2009 at 1:57 pm
The only way you can do that on SQL 2005 is to install a second instance, put some of the DBs on the second instance and change the CPU affinity.
2008's...
January 16, 2009 at 12:39 pm
colin Leversuch-Roberts (1/16/2009)
only if you haven't been using the san I've been testing!!!!
There are worse ways to kill a SAN's performance than RAID 6.
Share the OLTP system's fibre switch with...
January 16, 2009 at 12:14 pm
RAID 6?! I missed that.
That, by itself, is going to give you horrendous write times, especially for a tran log
January 16, 2009 at 11:36 am
TRACEY (1/16/2009)
Once i got the master working, the msdb, model i can do how?
See the link that Steve and I posted. It has sections for all of the system databases...
January 16, 2009 at 11:27 am
RSingh (1/16/2009)
So any thoughts about the time to dbreindex the?
It depends on the performance of the IO system, other activity in SQL, other activity on the server, etc. There's no...
January 16, 2009 at 9:28 am
krypto69 (1/16/2009)
I'm looking at Gails suggestion, but to be honest I don't think I have the skill to implement that correctly (that's embarrassing)
What suggestion? The query bits I posted were...
January 16, 2009 at 9:27 am
A quick google search brings up the following page:
http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx
January 16, 2009 at 9:22 am
That's probably it. Are there other data files from the same db on that disk?
The 'internal' snapshot that checkDB uses is created on the same drives as the data files....
January 16, 2009 at 9:20 am
You don't need the distinct in that, because of the group by.
January 16, 2009 at 9:13 am
Ah, that one.
SELECT productId, productnumber,
(SELECT top 1 LineTotal FROM Sales.SalesOrderDetail sd WHERE sd.productID = p.productid order by sd.ModifiedDate)
FROM Production.Product p
WHERE ProductNumber like...
January 16, 2009 at 9:06 am
dmc (1/16/2009)
January 16, 2009 at 8:57 am
Viewing 15 posts - 41,656 through 41,670 (of 49,562 total)