back up without ent manager.

As per earlier post my ent manager has stopped working and I have not been
ale to re-install it. I want to make full back ups of the database but have
never done this without ent manager.
Can I just copy the files in the data folder? or is there a better way.
JohnYou can easily use a batch file and OSQL
osql -S. -E -Q"BACKUP DATABASE Pubs TO DISK= 'd:\PubDeleteMePlease.bak'"
You could write something in VB and use the DMO library.
I would first though, and I haven't read you previous posts that you refer
to, I don't think, investigate why my EM is not working.
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"John Pether" <john@.john.com> wrote in message
news:#onkIILXDHA.384@.TK2MSFTNGP12.phx.gbl...
> As per earlier post my ent manager has stopped working and I have not been
> ale to re-install it. I want to make full back ups of the database but
have
> never done this without ent manager.
> Can I just copy the files in the data folder? or is there a better way.
> John
>|||Thanks for the help guys:) I have been trying to find out the reason ent
manager stopped working lal day...but its holding me up and I may be better
off just re-installing the whole thing(is on my dev machine)
The problem is the mmc snap in will not open, i get the following error:
MMC cannot open the file c:\program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC
This may be because the file does not exist, is not an MMC console, or was
created by a later version of MMC. This may also be because you do not have
sufficient access rights to the file.
I tried as local administrator and get the following error:
c:\program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise
Manager.MSC
The service cannot be started, either because it is disabled or because it
has no enabled devices associated with it.
If anyone has any suggestions I would appreciate the help other wise i'm
just gonna re-install the whole thing, I have already re-installed client
tools without success..
John
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:eQ9wXtLXDHA.1900@.TK2MSFTNGP10.phx.gbl...
> You can easily use a batch file and OSQL
> osql -S. -E -Q"BACKUP DATABASE Pubs TO DISK= 'd:\PubDeleteMePlease.bak'"
> You could write something in VB and use the DMO library.
> I would first though, and I haven't read you previous posts that you refer
> to, I don't think, investigate why my EM is not working.
>
>
> --
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "John Pether" <john@.john.com> wrote in message
> news:#onkIILXDHA.384@.TK2MSFTNGP12.phx.gbl...
> > As per earlier post my ent manager has stopped working and I have not
been
> > ale to re-install it. I want to make full back ups of the database but
> have
> > never done this without ent manager.
> >
> > Can I just copy the files in the data folder? or is there a better way.
> >
> > John
> >
> >
>|||In addition to what the others have said, you might want to look at =using WITH INIT
as in BACKUP DATABASE pubs TO DISK=3D'c:\pubs_fullbackup.bak' WITH INIT
This initializes (clears) the backup file each time.
If you don't do this...
Lets say that pubs is 15MB.
The first time that you issue a backup your backup file will be 15MB. =The second time that you issue your statement the backup file will =contain both backups -- 30MB. The third time that you issue your backup =statement it will be 45MB, the fourth time, 60MB....(plus any increase =in the size of the database along the way).
If you use WITH INIT your backup file will only contain one database =backup.
-- Keith, SQL Server MVP
"John Pether" <john@.john.com> wrote in message =news:%23onkIILXDHA.384@.TK2MSFTNGP12.phx.gbl...
> As per earlier post my ent manager has stopped working and I have not =been
> ale to re-install it. I want to make full back ups of the database but =have
> never done this without ent manager.
> > Can I just copy the files in the data folder? or is there a better =way.
> > John
> >sql