Viewing 15 posts - 4,786 through 4,800 (of 6,679 total)
Instead of trying to figure out how to do this from T-SQL, I would look at using SMO and Powershell to build a script that connects to every server\instance I...
July 27, 2009 at 10:32 am
luckysql.kinda (7/26/2009)
Is there any way to read the DB when this is in ‘Restoring’ mode. I tried SNAPSHOT but this didn’t help.-Lucky
What exactly did you try with Snapshot? And...
July 27, 2009 at 9:55 am
dh (7/24/2009)It was done thru a maintenance plan, which checks integrity, backs up the user databases, backs up the transaction logs then rebuilds indexes. The log portion happened successfully,...
July 25, 2009 at 1:45 pm
I wonder what it says about me that I actually enjoy reading all of these books that are supposedly targeted at teens? :hehe:
July 24, 2009 at 10:38 am
No - it is not possible. Why would you want to anyways?
July 24, 2009 at 9:08 am
jay (7/23/2009)
I apply the full backup with "norecovery" and apply Differential backup with "recovery". There is no requirement to apply transaction log backups.
Executed as user: TDS\clusadminspain. Cannot...
July 23, 2009 at 3:18 pm
Carl Federl (7/23/2009)
SELECTROW_NUMBER ( ) OVER (ORDER BY name ) AS NameId
,name
INTO#temp
FROMsys.objects
WHEREname NOT LIKE '#%'
SELECT*
FROM#TEMP
ORDER...
July 23, 2009 at 12:49 pm
Do you have any tables that do not have a clustered index? On tables where there is not a clustered index, the heap can use a lot more space....
July 23, 2009 at 12:41 pm
Once you restore your database with recovery, you cannot restore any additional backups. You have to restore the full database with norecovery, then you can apply the appropriate differential.
What...
July 23, 2009 at 12:26 pm
I honestly don't think your problem is necessarily related to security - at least, not directly. If a user does not have access to an object, you are going...
July 23, 2009 at 9:53 am
torpkev (7/23/2009)
I think I've been relying on the maintenance plans a bit too much lately (time constraints more than anything).. i think i'll just bite the bullet, mark off...
July 23, 2009 at 9:45 am
Are the tables in your sub-queries schema qualified? If not, is it possible that user has one or more of those objects in it's own schema that does not...
July 22, 2009 at 4:55 pm
Yes, you get everything in the transaction log. If you reach the max size that you have set - then your system is going to stop until there is...
July 22, 2009 at 4:53 pm
torpkev (7/22/2009)
I tried the view history, it was truncated.. that was my problem. I'll check those tables out tomorrow morning.Thanks
The history that you checked was from the job history...
July 22, 2009 at 4:31 pm
Where you are looking at the history is on the job - you need to look at the history for the maintenance plan. Right click on the maintenance plan...
July 22, 2009 at 2:21 pm
Viewing 15 posts - 4,786 through 4,800 (of 6,679 total)