Viewing 15 posts - 5,191 through 5,205 (of 9,253 total)
andersg98 (8/13/2012)
At the risk of adding confusion you can connect to an instance using a nonstandard (not dynamic) port and the server name without the browser service.example: Servername.domainname\instancename,port_number
you specify...
August 14, 2012 at 6:54 am
If <mask> is absent or 0, then no affinitywill be enforced.
:Whistling: 😉
August 14, 2012 at 6:51 am
ajay.g (8/14/2012)
I've a requirement to copy the files from one Server to another Server where they exist on diff. Domains. On first Server, we've administrative privileges with Domain accounts (like...
August 14, 2012 at 5:55 am
well firstly, each of the runs really needs to run for longer than 5 seconds to get any real metrics 😉
What are the results that are produced from the runs...
August 14, 2012 at 5:41 am
can you supply details of the config file you are using
August 14, 2012 at 2:40 am
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
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...
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...
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
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...
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"...
August 13, 2012 at 3:07 pm
alanspeckman (8/13/2012)
One last question.
Is it possible for 2 SQL Server instances running on...
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...
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...
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.
August 13, 2012 at 11:10 am
Viewing 15 posts - 5,191 through 5,205 (of 9,253 total)