Backup SQLServer database on JDServer
satya - 5/23/2015, 11:52:24 AM
Databases are backed up to: D:\host\c04\satya\backup\sql-server\database-only
Databases are backed up to: D:\host\c04\satya\backup\sql-server\database-only
satya - 5/23/2015, 12:11:10 PM
Database details
server type: database engine
name: jdserver\jdsql2008
auth: SQL Server authentication
Login: SatyaDBUser
satya - 5/23/2015, 12:24:46 PM
More details
start/sql server mgmt studio
userid/password
akc_prod
right-click
tasks
backup database
backup type:full
backup to: disk
flag: copy only
name: example: akc_prod_jul_01_2013
The backup file needs to be like:
D:\host\c04\satya\backup\sql-server\database-only\Jul-01-2013\akc-prod-copy-only-jul-01-2013
The complete filename not the directory!!
D:\host\c04\satya\backup\sql-server\database-only\akc-prod-copy-only-fix-date-later
You can use the above filename as is
satya - 5/23/2015, 12:27:49 PM
Here is the backup directory
C:\Users\Satya\Google Drive\emergency-server-bkp\database-backups\akc-sqlserver-database-backup