For DML transactions, hope there is nothing unless you create some user defined triggers with Audit tables.

Look at this...

http://www.sqlservercentral.com/Forums/Topic489349-357-1.aspx#bm489445

Yes, as above said, we can try to avoid the shrink option, unless you really needed to free up some space to OS. Have a look at the below link...

Backup and restore will help well instead of the Wizard option.

Also check this link, will give more idea.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=162455&SiteID=1

Good luck...

Im not sure, but you can try this. If you Install the Enterprise Edition on the same box then you can transfer the jobs using SSIS's Transfer Jobs Task, it...

Hope you've not added your new SAN drive in SQL group in Cluster Administrator.

Yes Jezemine, it is fine. I've managed my requirement without that details. Just curious to know.

Since it is session sensitive, could be it managed in buffer level without storing...

Yes, Jezemine is right.

I'm looking how to check that IDENTITY columns Current status, whether SET INDENTITY_INSERT ON/OFF for the column? I could understand, that is session/transaction sensitive, but still I'm...

Hi,

If you check in the following link the "Side by Side Upgrade" upgrade will help you well.

http://www.sqlservercentral.com/articles/Administration/2987/

and also other links to verify

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

Good luck.

Have...

Can you please explain bit more about the database restore issue part. I couldnt understand your problem exactly.

In my server i could see all the available drives.

If your SQL instance in cluster environment, then you can do only for the specified drive resources in the cluster administrator,...

Yes, As Tim said, after taking Tlog backup, you can use DBCC SHRINKFILE command as below

DBCC SHRINKFILE(logfilename, targetsize of the log).

"If there is any open transactions on the database, you...

Hi Alif,

Can you try the below steps on SSIS package on Control Flow task.

To Change Path

----------------

Right click On Backup database Task-->Edit-->On "Backup databases across one or more files"-->select and remove...

The SQL Server/Agent Service account must have enough access privilege on OS level on the specified servers. If not and that account have only in MS SQL level privilege then...

One more tip here...

A user database found bad/corrupted, but the transaction log file of the database is still available in good state, you can still back up the last active...