Viewing 13 posts - 1 through 13 (of 13 total)
Gila - I could not get that to work, but this does work:
--Switch to tempdb:
USE tempdb
GO
--empty out the .NDF file (I think you should start with the highest number)
DBCC SHRINKFILE...
August 18, 2011 at 2:54 pm
Lynn Pettis (2/5/2010)
subs99 (2/5/2010)
Lynn Pettis (2/5/2010)
The only t-log backups you need for a restore are those created AFTER the full backup completed.
Hmmm.. I'm not sure that's accurate... I thought that...
February 5, 2010 at 11:33 am
Lynn Pettis (2/5/2010)
The only t-log backups you need for a restore are those created AFTER the full backup completed.
Hmmm.. I'm not sure that's accurate... I thought that if a Full...
February 5, 2010 at 10:43 am
Alvin Ramard (2/5/2010)
February 5, 2010 at 10:33 am
GilaMonster (2/5/2010)
subs99 (2/5/2010)
February 5, 2010 at 10:23 am
GSquared (12/30/2009)
I prefer to create a domain account for that, domain\SQLBackups. Give it rights to the backup directories, give it rights in SQL, and be done with it.
OK, I...
December 30, 2009 at 9:07 am
Jack Corbett (12/30/2009)
Interesting question. I use sa and, interestingly enough, Tibor Karaszi has a blog post about this exact question today. Check it out.
Errr... I'm pretty sure he...
December 30, 2009 at 8:42 am
[font="Verdana"]Everything you ever wanted to know about SQL 2000 Maintenance Plans, Jobs and Owners!
Copy and paste this into SQL 2000 Query Analyzer and GO NUTS!!
(I would actually appreciate your feedback!)[/font]
/*
SQL...
December 16, 2009 at 1:19 pm
payal.dave (11/17/2009)
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY ('edition')
Thanks man!
I thought by making a really long original post with all the details I was being nice and clear or whatever.
But it...
November 17, 2009 at 9:58 am
Lynn Pettis (11/16/2009)
Why do you think that is rediculous? It just means that the data has many redundant bit patterns that allow it to be highly compressed.
Lynn - I...
November 16, 2009 at 1:32 pm
MANU-296622 (11/13/2009)
8.00.2055 SQL 2000 Service Pack 4 + Security Update KB960082http://www.bigdatabaselist.com/wiki/SQL_Server_Version_Builds
HTH!
Manu
Thanks, that helps!
I still think Microsoft should be the ones to create a database...
November 16, 2009 at 11:46 am
Thanks for the replies, but just so I'm clear on this -- there is no official Microsoft list of all the possible version of SQL 2000, right?
For example, I found...
November 13, 2009 at 8:00 am
Bru Medishetty (11/12/2009)
Microsoft SQL Server 2000 - 8.00.2055 (Intel X86)
Dec 16 2008 19:46:53
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
......
November 12, 2009 at 12:49 pm
Viewing 13 posts - 1 through 13 (of 13 total)