satya - 5/23/2015, 11:44:13 AM

There are some old notes here

There are some old notes here

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