If you are using SQL Server Express, you won’t find a UI to run periodic backups. In this case you have to run a batch using Windows Scheduled Tasks or something similar. Don’t forget to use a user with enough privileges to access SQL Server. In the batch file “C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE” -S (local)\SQLExpress … Read more
If you want to take a full backup i.e., all databases, procedures, routines, and events without interrupting any connections: mysqldump -u [username] -p -A -R -E –triggers –single-transaction > full_backup.sql -A For all databases (you can also use –all-databases) -R For all routines (stored procedures & triggers) -E For all events –single-transaction Without locking the … Read more
I had this situation restoring a database to an SQL Server 2005 Standard Edition instance using Symantec Backup Exec 11d. After the restore job completed the database remained in a “Restoring” state. I had no disk space issues– the database simply didn’t come out of the “Restoring” state. I ran the following query against the … Read more
The trick is to make COPY send its output to stdout, then pipe the output through gzip: psql -c “COPY foo_table TO stdout DELIMITER ‘,’ CSV HEADER” \ | gzip > foo_table.csv.gz
There are two parts to your question: Copying your settings between Eclipse installs Copying your installed plugins between Eclipse installs #1 is easy to do. You can export your Eclipse preferences from the File -> Export… -> Preferences. The resulting file contains all of your preferences for each installed plugin. It is portable between Eclipse … Read more
Amazingly enough in my case it was that the directory didn’t exists!! 😐 Is the error message a bug?… or it’s me. Tempted for the latter.
open SSMS and connect to the database go to MANAGEMENT > MAINTENANCE PLAN > pick your backup plan. > right click and view history. or to MANAGEMENT > sql server logs. directory location : c:\Program Files\Microsoft SQL Server\MSSQL.xx\MSSQL\LOG
Should be in Program Files>Microsoft SQL Server>MSSQL 1.0>MSSQL>BACKUP> In my case it is C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup If you use the gui or T-SQL you can specify where you want it T-SQL example BACKUP DATABASE [YourDB] TO DISK = N’SomePath\YourDB.bak’ WITH NOFORMAT, NOINIT, NAME = N’YourDB Full Database Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10 … Read more