Hi

I put correct statement only. I tried one statement at a time also. I am getting the output( command completed successfully) .But when i put sp_helpdb xxx then maxsize is...

Thanks.

I got the solution

No there is no table with that name with dbo I checked.

Hi gail.

It is a part of our job. Once in a month we have to stop mirroring and test both servers.Kinldy help me.

Hi,

I stopped the mirroring and checked the mirroring db.Next I have againg take full and tlog backup from primary server ,restored into mirrroing server and again configured mirroring.As the db...

Hi

I need a detail.This is my requirement.I have to stop mirroring temperoaly and check the morring db and primary db both having same data and need to reconfigure again. Pls...

Hi

Thanks for the reply.I need to confirm one more thing.Where I can restore 3 pm full backup and 4 pm tlog backup .

hi

Both my servers are sql servers.in linked servers I used the option 'connection to be made using the current security context.

I lgged into the server with admin id then the...

Issue DBCC SHRINKFILE ('Hr_database_log',TRUNCATEONLY)

I have a database with full recovery mode.Log file size is now grown to 50 gb

If i try to run dbcc shrinkfile('xx_log',2000) without taking log backup

what will happen...

1)check whether the login is windows or sql .

if the login is windows check whether login permission is granted.

2)For copying a table that has been deleted, first restore the database...

copy the file from remote server by using xp_cmdshell.Use DTS to export this file to the table.after loading delete the file

Thanks. But there it showing only default instance. How I can add other instances ?

Binu

Thanks

Thanks

What is the syntaxt in sql 2000 server

Binu