You cannot use the SQL Server agent in SQL Server Express. The way I have done it before is to create a SQL Script, and then run it as a scheduled task each day, you could have multiple scheduled tasks to fit in with your backup schedule/retention. The command I use in the scheduled task … Read more
The reason you see something pushed the second time is that –mirror pushes a little more than you expect. Apart from your local branches, it also pushes your remote branches, because mirror implies everything. So when you push normally (or with –mirror), mybranch is pushed and origin/mybranch is updated to reflect the new status on … Read more
I have very large databases with tens of thousands of tables some of which have up to 5GB of data in 10’s of millions of entries. (I run a popular service)… I’ve always had headaches when backing up these databases. Using default mysqldump it quickly spirals the server load out of control and locks up … Read more
Yeah I just scored this one. Look in Windows Services. Start > Administration > Services Find the Service in the list called: SQL Server (MSSQLSERVER) look for the “Log On As” column (need to add it if it doesn’t exist in the list). This is the account you need to give permissions to the directory, … Read more
You could maintain a second bare repo anywhere you want (like an usb disk), and push automatically on both remotes at once. See “pull/push from multiple remote locations”. That or you can setup a script which does a backup, which is called in Git a bundle. I have written recently a script which does: a … Read more
Use this: find . -type f -print0 | tar -czvf backup.tar.gz –null -T – It will: deal with files with spaces, newlines, leading dashes, and other funniness handle an unlimited number of files won’t repeatedly overwrite your backup.tar.gz like using tar -c with xargs will do when you have a large number of files Also … Read more
You can create a new db then use the “Restore Wizard” enabling the Overwrite option or: View the contents of the backup file: RESTORE FILELISTONLY FROM DISK=’c:\your.bak’ note the logical names of the .mdf & .ldf from the results, then: RESTORE DATABASE MyTempCopy FROM DISK=’c:\your.bak’ WITH MOVE ‘LogicalNameForTheMDF’ TO ‘c:\MyTempCopy.mdf’, MOVE ‘LogicalNameForTheLDF’ TO ‘c:\MyTempCopy_log.ldf’ This … Read more
In Microsoft SQL Server Management Studio you can right-click on the database you wish to backup and click Tasks -> Generate Scripts. This pops open a wizard where you can set the following in order to perform a decent backup of your database, even on a remote server: Select the database you wish to backup … Read more
You can try like this : @echo off set Source=C:\TEMP\MyDoc.txt set Destination=E:\MyData\ set Filename=MyDoc set a=1 :loop if exist %Destination%\%Filename%(%a%).txt set /a a+=1 && goto :loop copy %Source% %Destination%\%Filename%(%a%).txt pause