Hi,

So you mean to say that after 10 mins of job execution you are unable to retrieve the data as the connection is getting terminated. Did you...

Harsha,

You mean to say that whenever the job is running you are unable to retrieve the data using query analyzer and once the job gets completed...

Hi Kishore,

I dont understand why you are recommending harsha to run the dbcc commands. DBCC commands has nothing to do with this...

Hi Harsha,

How you are transferring data from one server to another. There are many ways like backup and restore, dts and bcp, database mirroring, logshipping...

Hi,

Please give the complete syntax for DBCC CHECKDB. From the error message you had posted it looks like a page got corrupted. I think you can go...

Hi,

First of all I dont understand why you want to move all the disks and why it is needed. Instead you can do a backup and restore. This...

Hi,

There is no way in sql server where you can restrict the backup file size. One way is reduce the transactionlog backup schedule from every 15...

Hi,

Which authentication you are using sql or windows (for you not for usera and userb) and what permissions does ur account have

Thanks

Chandra Mohan N

Hi,

SA is correct. I dont know why did you kill the restoration process. Before killing any process you have to think twice. Its better to drop...

Hi,

You can get the previous error log using the following command in master database. Also can you check the event viewer of the server. There might be...

Hi Pramila,

Why dont you go for a filegroup backup. I think litespeed doesn't support splitting of backup's. Check out the help file of litespeed. It...

Hi Karan,

You are totally wrong. Even if you system admin tries to install both as default instances sql server wont let you. Run the...

Hi Mani,

Before upgrading did you check all the prerequistes for installing 2005

1. What is the current sp on sql 2000. (Because sql 2000 with sp3...

Hi,

As you had installed both sql2k and sql2k5 in your system. One might be the default instance and another one as named instance. And at a...

Did you check whether all your agents are up and running fine