March 27, 2006 at 8:58 pm
Hi,
Do anyone know how to backup Analysis database in SQL Server2005.
Pls help me
from
Killer
March 29, 2006 at 1:37 am
March 29, 2006 at 1:41 am
1. Via SQL Management Studio, connect to the analysis service.
2. right click database and select backup
Derek
March 29, 2006 at 2:05 am
Hi,
Thanx for ur reply , i already did that.I want to know how to backup from command prompt.
from
killer
March 29, 2006 at 2:31 am
Uh You might have been a little more specific in your question.
anyway, do the same thing via the GUI and then in the backup dialog screen ensure you select what path you want the backup to go to and then use the scriptout icon to capture the backup sql created. You can then save this SQL and execute via batch, sqlcmd etc.
March 30, 2006 at 10:06 pm
Thanx Derek.
from
Killer
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply