Can't be done directly from t-sql. You need to invoke the command line using xp_cmdshell. There are plenty of zip tools around which provide a CLI and give...

That's a good point. You will need to change the paths back to what they were or next time you restart the db will fail to come online.

Just...

You can't physically move files whilst the db is in use. You can set the db to offline then move the physical files and combine it with the method...

deep_kkumar (12/31/2013)

---

S_Kumar_S (12/31/2013)

---

for the benefit of those who fall across this thread, here is I solved this:

I created a proc on main server which was schedule and it will delete...

muthyala_51 (12/31/2013)

---

Jimbo,

Thanks for the info. I am talking about transactional replication. Recently I noticed one of our subscription in inactive state. So I just right clicked on that subscription in...

Here's a couple of articles for you to look into it.

http://bradmcgehee.com/2011/03/10/do-you-enable-lock-pages-in-memory/%5B/url%5D

https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/%5B/url%5D

In my case, the only reason this option wasn't enabled was based on a MS article at the time saying...

I...

This may or may not be of help. We had a similar problem, on an older version of windows, and this was related to not enabling "background memory trimming"...

I've only just seen this post. Your solution is precisely what I was about to suggest. There is no other way to achieve it.

Its difficult to say. There is no magic option to speed up the shrink command.

You could see if you have any unused/unrequired indexes and tables first. Maybe create...

You need to capture the deadlock and provide the output to establish the source of the problem.

It's could be caused by the delete in this case but could...

Have you got a db upgrade script? You should be able to include this as an executable to upgrade the in-situ db.

If not you can use a third party...

If you mean bi-directional in the form of transactional replication, you should go down the route of peer to peer replication. I'd stay away from updatable subscriptions as that's...

That's a pretty vague statement. Have you read the Microsoft documentation? Is this snapshot/merge/transactional replication?

There are many customisable options, such as initialise from backup, which can effect the...