Perry Whittle

Forum Replies Created

Viewing 15 posts - 6,271 through 6,285 (of 9,244 total)

RE: Backup and old file delete GOTCHAs!

mfreeman 45141 (11/7/2011)
I have a related question. When I delete a full backup, I would like to delete all the files that are rendered useless once that full backup has...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 7, 2011 at 11:38 am

#1404123
RE: Restore Database

Jonathan's C# script here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 7, 2011 at 10:57 am

#1404103
RE: Restore Database

You can do this via SSIS or Jonathan Kehayias showed how to this directly through SMO. I'll see if i can find the link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 7, 2011 at 10:51 am

#1404101
RE: sql server doesnt come online

they more than likely deleted a system database by mistake, as Gail says error messages please!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 7, 2011 at 10:47 am

#1404099
RE: MSDTC resource not coming online

Windows 2003 or Windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 7, 2011 at 10:45 am

#1404098
RE: SQL Backups copy top network

In a maintenance plan not sure don't use them myself. Via T-SQL, use the mirror capability in the backup database command like so
BACKUP DATABASE AdventureWorks
TO DISK = 's:\mybackups\somedatabase.bak'
MIRROR TO DISK...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 7, 2011 at 10:31 am

#1404091
RE: Reporting Services

Check the Windows services for a SQL Server Reporting Services service
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 7, 2011 at 10:30 am

#1404090
RE: How to modify code to display '21:30:00 PM' as '09:30:00 PM'?

This
declare @date datetime
set @date = '2011-11-08 21:30:00.000'
select CONVERT(VARCHAR(30), @date, 109)
Or this
declare @date datetime
set @date = '2011-11-08 21:30:00.000'
select CONVERT(VARCHAR(30), @date, 100)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 7, 2011 at 10:29 am

#1404089
RE: Security account for log shipping in cluster environment

alark (11/4/2011)
We need to set up a log shipping for SQL-2005 SP3 instance in clustered environment to DR server. The cluster and DR are in absolutely different domains that don’t...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 6, 2011 at 3:45 pm

#1403744
RE: identify insert

how are you loading the data?
as GSquared has already pointed out you must set identity_insert on within the same session
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 6, 2011 at 3:41 pm

#1403743
RE: sql start up problem

in fact, don't start SQL Server in single user mode by modifying the startup parameters, stop the service and then use the command prompt to start your instance in single...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 6, 2011 at 3:37 pm

#1403742
RE: How can we find a particular process id to belong which instance ?.

to find the Windows process id for an instance of SQL Server you can also use SQL Server configuration manager 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 6, 2011 at 3:34 pm

#1403741
RE: MSDTC resource not coming online

Minaz Amin (11/5/2011)
Iam not able to bring the MSDTC resorce online. This is on windows 2008 R2 (SP1). I have create computer objects permission and manually also I have created...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 6, 2011 at 3:29 pm

#1403740
RE: Swapping a server in a mirroring setup

Everything Ok up to here
Steve-443559 (11/1/2011)
3. Failover the Mirror so that the PHysical Server is the Principal (because the physical server is beefier)
Just install the database onto the physical...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 1, 2011 at 9:24 am

#1401696
RE: Identity value Reset

Don Bricker - Illinois (11/1/2011)
This is not the most elegant way, but it should work. Export all data to a temp table (identical structure as the original including identity field)....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

November 1, 2011 at 8:22 am

#1401652

Viewing 15 posts - 6,271 through 6,285 (of 9,244 total)