Viewing 15 posts - 5,191 through 5,205 (of 9,244 total)
tilew-948340 (8/13/2012)
Perry Whittle (8/13/2012)
use this to delete backup\restore history for a specific database
use msdb;
go
exec sp_delete_database_backuphistory @database_name = 'yourdbname'
Seems to do the job!!!!
Thank you very very much!!!
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 2:37 am
The index procedure in Olas script outputs to a table have checked this table for any results?
It may be possible that no indexes are found for defragging in this particular...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 12:21 am
Cairbre (7/9/2009)
I've been told by our architect/infrastructure guys that adding more LUNs will help.
Hmmm, yes. Pushing more I\O queues down to the disks will likely just saturate them, then your...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 4:02 pm
I believe you change this
@Databases = 'USER_DATABASES -Z%', @LogToTable = 'Y'" -b
To this
@Databases = 'USER_DATABASES, -Z%', @LogToTable = 'Y'" -b
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 3:39 pm
SQLRNNR (8/13/2012)
http://msdn.microsoft.com/en-us/library/ms177182.aspxThere is a maintenance plan option for backup history cleanup.
That cleans up the actual physical backup or text files and essentially just executes
xp_delete_file
It does not clear the actual...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 3:09 pm
tilew-948340 (8/13/2012)
Many of the backups are bad (have bad data) and I want to remove them from the possible "backup"...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 3:07 pm
alanspeckman (8/13/2012)
One last question.
Is it possible for 2 SQL Server instances running on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 2:57 pm
If the database is really small then I'd take a full backup, but mostly i would take a diff pre the upgrade and use this plus the full to restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 2:33 pm
good article but unfortunately it makes the same mistake regarding master keys that others make.
To restore a TDE protected database to another server you do not need to backup and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 2:23 pm
I had an example only this morning. A RAID array failed that contained some database files and the databases were marked as suspect.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 11:10 am
tilew-948340 (8/13/2012)
How do you put the option to "simple"?
Using T-SQL
ALTER DATABASE yourdb SET RECOVERY SIMPLE
[/CODE]
Or using SSMS GUI, right click the database and select properties. On the database properties select...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 10:14 am
GSquared (8/13/2012)
GilaMonster (8/10/2012)
GSquared (8/10/2012)
All I asserted is that multiple I/O channels is best, if tempdb optimization is needed. I don't get why that's being disagreed with.
Late, and I have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 8:21 am
no, standalone is completely different, it mentions this in the link i posted 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 9:52 am
i only recommend changing the network name if you really have to
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 9:43 am
http://msdn.microsoft.com/en-us/library/ms178083.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 9:31 am
Viewing 15 posts - 5,191 through 5,205 (of 9,244 total)