In SQL Server 2008 you can do copy only backup with GUI and you can script it as T-SQL, then creating the Maintenance Plan for schedule with that T-SQL.

Jeffrey Williams-493691 (1/14/2010)

---

Wrong - COPY_ONLY is not available when using the GUI in SSMS 2005, however - you...

I really don't know why he or they want to do copy only backup with SSMS with schedule, for that reason if really they want to do it they can...

...also with no data...any reason why do you need that!?

copying...

I understand...

Maybe it can be done with other alternatives, but the...

Copy Only Backup with SSMS are supported just in SQL Server 2008!

http://msdn.microsoft.com/en-us/library/ms187510.aspx

xxdbxx (1/14/2010)

---

You can definitely create a job within SSMS to run a piece of SQL code which could be a Copy Only Backup.

And I really have no idea...

I think that with SSMS you cannot do it as schedule!

You should create PowerShell script that will stop the SQL Server services, copy files from folder to other folder, then...

So the problem solved with re-installation or anything else!?

A composite column is a violation of 1st normal form

As DBA I agree, as developer I cannot understand the developers, why they allow these things during the large Database design!?!...

homebrew01 (1/12/2010)

---

When making changes with the GUI (table changes, backup, restore, jobs ...), before you click the final "OK", you can script out the change that's about to be made....

Example:

You have table TEST and one of the columns that you want to change is LASTNAME NVARCHAR(50) and you want to change it to NVARCHAR(100), you will do like this

ALTER...

GilaMonster (1/12/2010)

---

Dugi (1/12/2010)

---

I said before that large and medium DBs have tables that the Identity Col has generated value with combination, and the last value can be sequence number that...

You can do it with T-SQL like:

ALTER TABLE YourTable

ALTER COLUMN YourColumn Datatype(new size)