The repair will not be done if it is not set to a single mode! The answer is YES.

"i want to know can we restore from network drive and how ???????"

The answer is yes, check this out http://www.mssqltips.com/sqlservertip/1126/sql-server-backup-and-restore-to-network-drive/

You need to first see if you can...

Thanks for your input, will do the datafiles than the whole database.

Gail -

Yes, I am not doing it to improve performance. It is a one time thing I have to do shrink because large data was deleted and now we have...

Gail,

How about if I do: DBCC SHRINKDATABASE (dbname, 10)? Would that better? There are over 20 datafiles in the database.

Thank you!

Lava

Gail - As always, I enjoy reading your answers... Thank you.

you mentioned that by just rebuilding the indexes, that should help... I have to say, I run into same situation,...

As you recommended, I will be using vb script to delete... Thanks for you reply.

You are correct, it is SQL 2k. It does not come with xp_delete_file.

Sorry, forgot to update this post... First thing first i was typing sqlcmd -s, it should be upper case -S servername\instancename. I first created a stored procedure to backup the...

I found this very helpful link so that answered my question,

http://connectsql.blogspot.com/2012/06/sql-server-script-to-fix-allowpagelocks.html

Great, will try it and see if it works. Thanks.

I am on the machine when trying to run the SQLCMD. I have other SQL versions elsewhere to use, can you please guide me to how I setup a package...

Below is what I got. How about using stored procedure? All I need is to have a job truncate two tables from two different databases to get truncated on weekly...

I do have a named instance, and i did use the correct name. What I saw is that named pipe for that instance is disabled. I can connect to the...

Named Pipes Provider: Could not open a connection to SQL Server [2].

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi

shing a connection to the server. When...