Viewing 15 posts - 9,166 through 9,180 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:38 am
what state do you require the replicated database to be in?
standby or full access
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 6:20 am
rinu philip (7/16/2008)
Now if the target size is not reached with the above command, we can go on to truncate the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 3:21 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 3:15 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 4:29 pm
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"...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 3:50 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 3:45 pm
Jay Murthy (7/16/2008)
declare @val1 varchar(25),@VAL2 varchar(25)
SET @val1 = ''
SET @VAL2 = 'W'
If 'W' In(@val1,@VAL2)
Begin
PRINT...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 11:05 am
yes, its under HKLM\SYSTEM\currentcontrolset\services but i find a WMI query easier personally
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 10:06 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 9:53 am
do you have any databases you want to keep?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 9:34 am
sqluser (7/16/2008)
Hi Perry,Could you please elaborate more for the same?
---
open the services console from administrative tools and check the sql service properties. A default instance will have the service name...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 4:40 am
check this link
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
as for cost, who do you normally purchase licences from ?
Give them a call and get a quote would be best?
Basically Ent allows online indexing , max CPU...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 2:19 am
check the services.msc console or enumerate through code
a default installation of SQL server will have the following service name
MSSQL$SERVER
for a named instance it will be
MSSQL$instancename
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 2:03 am
a.thomson2 (7/15/2008)
CREATE PROCEDURE@EmailTo nvarchar(250)
AS
BEGIN
SET NOCOUNT ON;
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'VoiceSQLMail',
@recipients = @EmailTo,
@body = 'Testing';
END
is this a typo, your...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 1:57 am
Viewing 15 posts - 9,166 through 9,180 (of 9,244 total)