I am perfectly at ease with sqlstudiomanagementexpress or sqlserver.

What i meant was my clients are not too familiar with these and i need a solution for them.

OK can you tell me how exactly to do that.

I am always open to ideas and appreciate every thing that would make doing anything in a better and optimized way.

Yes i did finally achieve this with these command in a bat file.

cd D:\sqlbackup

sc stop mssql$sqlexpress

copy "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\hospital_log.ldf" D:\sqlbackup\ /Y

copy "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Hospital.mdf" D:\sqlbackup\ /Y

sc...

superb

This is exactly what i wanted and it serves my purpose quite well.

Thanks RP_DBA.

I really hope you would help me out with this query.

Table trans has the following structure

...

Sorry for the haste.

The above query is working for my purpose.

Next what i am trying to do is to get a list of all acctid , and their balances using...

After posting i did tried and write the query as follows

SELECT c.invdate,a.acctname,COALESCE(c.invamt, 0) AS Debit,0 AS credit

FROM invoices c

INNER JOIN accounts a ON a.acctid = c.acctid

WHERE a.acctid = 3

UNION...

Tables are

1.Med Fields are MedicineCode primary varchar(10)

MedicineName ...