Easiest method is

1) Shutdown your SQL instance

2) move all database files to new drive ( make sure you don't change order or the folder names or so within..)

3) Remove...

Thank you all for the reply,

My problem is that

1) tableA.IP1 has Nulls

2) TableA has more data that's hard for me to compare based on just one column value...

3)...

Thank you for pointing

oops sorry, just edited my post.

Hi,

Thank you that worked.

either way works, I tried with move option and created a sql agent job to automate the backup\restore jobs.

Thank you very much! that really worked... just adding the text in single quotes and defining '.mdf' and '.ldf' to variables really worked...

Hi Wayne,

here is the code that I am trying to write..

declare @db_name nvarchar(255), @db_location_name nvarchar(255), @db_log_name nvarchar(255)

, @db_name_time nvarchar(255);

set @db_name = 'test';

set @db_log_name ='test_log';

set @db_location_name='c:\temp\test.bak';

set @db_name_time = 'test01' ;

Restore database...

Hi,

Thank you very much for quick reply. when I try to put the quotes then I get the error as

Incorrect syntax near +

any ideas of what I...

Hi,

Thank you for the clarifying. we are setting up asynchronous with possibility for High Availability.

my other question is that can i install the witness server in a virtual environment...

Oh what a miss.. Thank you for catching it.

Hi,

Thank you for suggestions. the concatenation is not a major issue right now. but what I wanted to do is that

pass column values to @db_name variable and use this variable...

all I get is an error

"The step did not generate any output. Process Exit Code 8. The step failed."

No other information else.