| Author |
backup for SQL Server Express
|
|
|
| Can someone tell me how to backup SQL server express 2005?
| |
| Uri Dimant 2006-10-24, 6:37 pm |
| Joel
BACKUP DATABASE dbname TO DISK='C:\dbname.BAK'
"Joel" <nowhere@nowhere.com> wrote in message
news:%23j4pEsg7GHA.4116@TK2MSFTNGP03.phx.gbl...
> Can someone tell me how to backup SQL server express 2005?
>
| |
|
|
| Sue Hoegemeier 2006-10-24, 6:37 pm |
| And if you are using Management Studio Express, you
can use the backup dialog from object explorer or backup
templates. You can find details on these methods in the
following article:
http://www.microsoft.com/technet/pr...lexpwssmse.mspx
-Sue
On Thu, 12 Oct 2006 09:30:49 -0500, "Joel"
<nowhere@nowhere.com> wrote:
>Can someone tell me how to backup SQL server express 2005?
>
| |
|
| I have created a DTS and job that controls all my SQLExpress backups
from a central location. I use xp_delete_file to dump old files.
Permissions needed to be set up for the account running the central
instance. (I imagine this could all be done with SSIS)
If you email me, I can send you some files.
Terry
Uri Dimant wrote:[color=darkred
]
> Joel
> BACKUP DATABASE dbname TO DISK='C:\dbname.BAK'
>
>
>
>
> "Joel" <nowhere@nowhere.com> wrote in message
> news:%23j4pEsg7GHA.4116@TK2MSFTNGP03.phx.gbl...
|
|
|
|