http://support.microsoft.com/kb/307487

if you cant shrink the file it means something is using the space, find out what, kill the session drop the object etc then shrink the file

i wouldnt shrink tempdb...

first thing I would look at is what caused tempdb to grow, index rebuilds being done in tempdb, excessive sort operations, increased number of temp tables table variables etc.

shrinking the...

yep through powershell, there is a variable at the top for the servername, think its set to localhost as default in the script.

make sure you have c:\temp directory as well...

baabhu (2/16/2012)

---

Hi Bhuvanesh,

I am not trying to reclaim the space. But I am just curious what will happen if the empty space is available in the data files. As...

I'm pretty sure this cannot be done, as I believe you have to restore the filegroup back to the original database it was backed up from, as I had an...

List of keyboard shortcuts for SSMS

http://www.simple-talk.com/sql/sql-training/ssms-the-query-window-keyboard-shortcuts/

happy to help as always

always good to give the error log a good read usually contains the problem your facing

Well thats a different kettle of fish all together, as its a system database I wouldnt backup and restore it as your upgrading, yet script all the SSIS packages out...

If you want to use the default instance where you just use the servername to connect via SSMS etc then you need to uninstall 2005 first (that is if 2005...

Do you want to run 2005 and 2008R2 side by side? If so you will need to create a named instance of 2008R2.

During the install it will ask for...

problems in the error log

Error: There is insufficient free space on disk volume 'L:\' to create the database. The database requires 15587278848 additional free bytes, while only 8799973376 bytes...

Couple of things to check

Is SQL Browser started so that port numbers can be translated?

Can you connect using the port number for the named instance? SERVER\Instance,1433

Server firewall blocking the...

you want 1 query executed against 10 servers at the same time?

so going back to my original post, use a central management server or create a batch file which uses...

Hi Guru

Thats a completely different thread as you can see in the URL's.

The OP has the same question but two different SQL queries hence the two different posts.

Thanks

Ant

you could use a central management server to execute the same query across multiple servers in one go, or if you want to do it in a batch file take...