Actually downloaded express edition and installed.

Thanks.

Thanks It is working now.

Thanks.

ChrisM@Work (10/9/2012)

---

zahid_7777 (10/8/2012)

---

I just like to know the command to copy data (specific range like 10 rows) containing in a COMPANY_CODE and will be copied to another COMPANY_CODE starting with...

I just like to know the command to copy data (specific range like 10 rows) containing in a COMPANY_CODE and will be copied to another COMPANY_CODE starting with a new...

SELECT *, [COMCOD]

,[ACTCODE]

,[ACTDESC]

,[ACTELEV]

,[ACTTYPE]

...

Thank you very much.

Thanks. I will do as you suggested. I hope this is very useful. One thing,

* should I mention zero day or more days for expire last backup option to reduce...

Maintenance plan giving error message. But I am right clicking on the database then selecting task and next backup after that selecting the options like expires 1 day, recurring daily,...

May be you are right I will create new backup policy, by adding recurring, daily, expires in 1 day and append option selected. But where can i found append option...

I just scheduled for backup as recurring, daily, expires 1 day and started sql server agent along with the jobs under it and getting the scheduled backup, but backup steel...

Right clicking in the database selecting task then backup, assigning job by selecting script action to job generated by sql server and schedule. Not maintenance plan or writing any script...

Actually I don't know. How to know this and change the configuration.

.mdf = 80 Mb

.ldf =26 Mb approximately.

It was configured in backup job with the option full database backup.

Whereas .bak file producing 350MB. Did I configured wrong? If I did then...