My Team Foundation Server creates backups. I want to clear backups that are older than 5 days. Create Maintenanace Cleanup Task in Maintenance Plans of Management of Sql Server 2012. Point there folder, file extension bak, checkbox 'Delete files based on the age of the file at task run time' is checked. Saved task.
When I execute it, got error: Execution failed.
I have a Team Foundation Server 2012 installation with Power Tools, and I defined a backup plan using the wizard found in the "Database Backup Tools" in the Team Foundation Server Administration Console.
I set the backup plan to do a full database backup on Sunday mornings, to another server in the network.
I followed the wizard with no problems and the Backup Plan was set successfully.
However wh
I am looking at consolidating all of our scheduled tasks that run on various servers (Win 2008 R2) within our domain on to one "Task Scheduling Server". I am a developer so I'm not even sure if this is a good idea or just a maintenance headache. One of our Network guys copied some of the tasks I monitor over to the new server and asked me to test them.
MSSQL 2005
An old maintenance plan was backing up a database to a single disk based media set with append. It contains numerous full backups of about 2GB each. I now have a single media set file almost 0.5TB in size.
Is it possible to easily split this media set into individual .bak files?
I have now changed our maintenance plan to backup to individual files rather than a single disk device.
I have a SQL 08 Standard box that I would like to use a Maintenance Plan to backup a database over a network share? Is this possible as the GUI won't let me do that? It tells me it can't find the path. The SQL service has permissions to write on the share.
I login to a dedicated Windows 2003 server, under Administrator, with a remote desktop client, Microsoft RDC.
After 5 minutes of inactivity the server shuts me out and I have to reload RDC and login to the server again. This is good for security but I think this is causing problems for a Windows Schedule backup task I am running.
I'm trying to do something with a Capistrano task that is similar to the heroku db:pull functionality if you are familiar with it.
I have a remote server. On that server I have a bunch of backups in the /path/db_backups/ folder.
I'm in the process of upgrading our small SQL databases to SQL Server 2012. We have at least 3 instances, (1) Critical work databases, (2) low-importance System Maintenance databases, (3) WSUS.
Can I specify a priority with which these instances run?
ie, the Critical databases should run at normal priority. During resource contention they should respond the fastest at all times.
I am having a problem performing maintenance tasks on Microsoft SQL server 2008 after changing my server name from the original random name given during installation to the one I prefer
This is the error am getting
Could not obtain Information about Windows NT group/users
'WIN-4N4A9TLBGJJ\Administrator', error code 0x534
Is there a way i can rectify this problem without having to delete t
Email this page
