How to backup a database in MSSQL Express?
Hi there;
I have MSSQL Express and Microsoft SQL Server Management Studio Express...
I want to know how to backup a database in MSSQL Express? Are there any best practices?
Best regards...
I have MSSQL Express and Microsoft SQL Server Management Studio Express...
I want to know how to backup a database in MSSQL Express? Are there any best practices?
Best regards...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
tapanpattanaik:
Ok...It works...Before granting points...
Igor-K:
>>If you will want to schedule using Windows Scheduler, then write a cmd script. You should utilise >>the command sqlcmd. It allows command line execution.
Could you give me an example script?
>>Alternatevly to schedulers you can use Service Broker. But you would need to get familiar to it.
Is service broker coming with .NET 2008?
Ok...It works...Before granting points...
Igor-K:
>>If you will want to schedule using Windows Scheduler, then write a cmd script. You should utilise >>the command sqlcmd. It allows command line execution.
Could you give me an example script?
>>Alternatevly to schedulers you can use Service Broker. But you would need to get familiar to it.
Is service broker coming with .NET 2008?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
check this link also
http://www.targetprocess.com/support/faq/DatabaseBackup.aspx