Hello Satnam,

Were you able to create the new instance. And what steps did you follow?

Hello Pat,

I am also in the process of installing a new instance on a sql 2008 cluster. I am going over this documentation right now:

This might help!

Thanks for the link. There should be a feature to be able to delete a post.

Thank You Daniel. I posted this here by mistake...multi tasking does not always work!

Thanks for the update Koen, i will work on this solution right away.

Thanks!

Abhi

So this what i have changed again

1. Read file name and write the file name in a table. (7000+ rows)

2. Run a query to see if the file exists in...

Hello Koen,

Wonderful option, worked like a charm. I guess i was over thinking into the problem.

Now the other confusing part.

So this is what i am doing:

1. Read file name and...

Hello Jeff,

Thank you for the suggestion. I would love to do what you asked me but unfortunately these tables are from a really obsolete software and there is no way...

Hello Lutz,

Thank you for your quick reply.

This is what i did, since the amount of data was quite huge i copied the 2010 data to a staging table.

However when...

Hello Ron,

This is the table definition:

CREATE TABLE [dbo].[Test1](

[EMPLOYEENAME] [char](32) NULL,

[EMP_ID] [int] NULL,

[CLIENT_ID] [int] NULL,

[BEGINDATE] [datetime] NULL,

[STARTTIME] [varchar](10) NULL,

[ENDTIME] [varchar](10) NULL,

[SIGNDATE] [datetime] NULL,

[SIGNTIME] [varchar](10) NULL

And yes your insert statement would work...

Thanks, I did not know about the Compress option. I am going to test it on a development server to see the difference.

I am taking backup using maintenance plans.

These are...

Thank you for the quick response. The databases are fine, its just the .bak and Transaction Log file size. The data drive where we store them becomes difficult to access...

Steve,

What is a proper way to shrink Transaction Log files for a database that's set to a Simple Recovery mode?

Thanks.

Abhijit Chaudhary

You got that right Paul, the databases are not too big, except one.

However i did not understand why we should not shrink the databases. I thought that would be a...

Thanks for your reply.

I was hoping there would be a way to generate this file in excel and then do the Send mail task.