well done!!

jsgault (7/14/2008)

---

I checked the firewall log & found lots of DROP UDP entries coming through so started fiddling....

just change fileid to 1 instead of 2 as below

select a.name, b.name as 'Logical filename', b.filename from...

if you have the original SP2 file sitting around on the network remove it and replace it with the latest so it doesnt get re deployed in future 😉

what disk set up (RAID arrays, etc) are you using on your SQL server

you don't need to detach the database

set the database offline using

ALTER DATABASE mydatabase SET OFFLINE

you can then do what you like with the disk files (even delete them). Move the...

what state do you require the replicated database to be in?

standby or full access

rinu philip (7/16/2008)

---

Hi, here's an example to explain : DBCC SHRINKFILE(testlog, 3)

Now if the target size is not reached with the above command, we can go on to truncate the...

Ratheesh

i would install SQL2005 developer alongside as a separate instance.

move databases, logins, etc to the new instance.

remove the old one when finished.

script the logins off using the MS script at

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

detach...

i'm using Redgate SQL Backup v5.x, its a great product offering good speed and very high compression. It also gives us 256bit encryption which we need for our backups. Very...

hi yes you can move the files and also add new files

First set the database offline.

Copy the current disk files to the new location.

Use the "ALTER DATABASE MODIFY FILE"...

at the end of the day SQL Server is just another application, the OS is the fundamental part of the equation. Every DBA whether Oracle\SQL\etc should understand and be able...

Jay Murthy (7/16/2008)

---

A Q. are following 2 queries same or diff and why?

declare @val1 varchar(25),@VAL2 varchar(25)

SET @val1 = ''

SET @VAL2 = 'W'

If 'W' In(@val1,@VAL2)

Begin

PRINT...

yes, its under HKLM\SYSTEM\currentcontrolset\services but i find a WMI query easier personally

here you go try this, reports database name, logical filename and log file locations for all databases on an instance

select a.name, b.name as 'Logical filename', b.filename from sys.sysdatabases a

inner...

do you have any databases you want to keep?