Viewing 15 posts - 5,191 through 5,205 (of 9,241 total)
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
robert.baird 2778 (8/10/2012)
Could I in fact change the Network name of the cluster? Not the nodes, just the network name (resource).Dan
network name for the windows cluster or the clustered sql...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 9:08 am
robert.baird 2778 (8/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 9:06 am
muthyala_51 (7/27/2012)
i want to create a new distribution database and make the present publisher use this new distribution database.
This is bugging me :ermm:
but why do you want the present publisher...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 8:43 am
Viewing 15 posts - 5,191 through 5,205 (of 9,241 total)