Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

I just became Keeper of the Ring. And I'm Boromir. Expand / Collapse
Author
Message
Posted Friday, January 11, 2013 5:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 7,094, Visits: 12,582
Jamie Scharbrough (1/11/2013)
Sorry, not downloaded, I used the wrong word.

Yeah that's definitely doable (installing it on my workstation). I'm so used to everything being in the same place that I kind of panicked when I realized it wasn't there.

EDIT: Oh good grief. The original installation disks are overseas. And there would be some serious other issues in trying to get them. (The long and the short of it is, our parent company has disassociated from us and legally we are no longer allowed to work with them. It's complicated.)

Is it possible to download the 6 month freebie SSMS that Microsoft offers, or would there be issues in connecting them?

I am not sure if a SQL 2005 Evaluation download is still going to be around, but you can download the 180-day Evaluation copy of SQL 2012 from Microsoft's website and that will get you a copy of SSMS. SSMS 2012 can connect to SQL 2005 instances. You may run into some quirks trying to manage some of the subsytems (e.g. replication) but Microsoft touts that SSMS 2012 can manage SQL 2005 instances. This would only be a stopgap until you got the SQL 2005 media and could install SSMS 2005, or upgraded to SQL 2012


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1405940
Posted Friday, January 11, 2013 5:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 8:43 AM
Points: 37, Visits: 82
Okay so I emailed the original IT guy, asking him to doublecheck if the disks were over there or not.

...It turns out he'd been using Arcserve the whole time and he has no idea how SQL 2005 got onto our server.

I have no clue how to use Arcserve and I'd really feel better using SQL. However, we're only running one instance of SQL, our data backups are relatively small, and I have no idea if we'd be willing to fork out the cash for a Enterprise edition of 2K12 or 2K8.

I know I can download the trial copy and use it, but the question is, should I? And essentially start from scratch?

I want to personally, as this will give me great hands on experience and I can begin anew.

What would you guys do in my position (beside crack open the vodka at 8 am and keep going until you can't stand up)?


_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2
Post #1405944
Posted Friday, January 11, 2013 5:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 7,094, Visits: 12,582
JESDBA (1/11/2013)
Okay so I emailed the original IT guy, asking him to doublecheck if the disks were over there or not.

...It turns out he'd been using Arcserve the whole time and he has no idea how SQL 2005 got onto our server.

I have no clue how to use Arcserve and I'd really feel better using SQL. However, we're only running one instance of SQL, our data backups are relatively small, and I have no idea if we'd be willing to fork out the cash for a Enterprise edition of 2K12 or 2K8.

I know I can download the trial copy and use it, but the question is, should I? And essentially start from scratch?

I want to personally, as this will give me great hands on experience and I can begin anew.

What would you guys do in my position (beside crack open the vodka at 8 am and keep going until you can't stand up)?

If ArcServe is not "SQL Server"-aware then you probably do not have valid SQL database backups. I am not too familiar with the product but from a couple minutes on their site it looks like "SQL Server"-awareness is optional. I would say, start taking native SQL Server backups immediately. I would probably do that regardless since recovering a database from a file system backup is not always going to give you what you need.

Installing SSMS locally so you can manage the 2005 instance is not necessarily starting from scratch. I do not see it that way. The server will still be 2005. SSMS 2012 is slightly different with some of the keyboard shortcuts, but not drastically different than SSMS 2005 so much that you will not recognize it.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1405953
Posted Friday, January 11, 2013 6:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 8:43 AM
Points: 37, Visits: 82
I'm currently talking to a tech friend of mine and browsing Arc's website.

It looks like we've just been using it to backup our FILES, not our database. Sorry, it's early, I have the dumb (and the inexperience).

I'll be taking backups of SQL and downloading SSMS on my workstation.

Thanks for the advice!


_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2
Post #1405970
Posted Friday, January 11, 2013 7:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:49 PM
Points: 191, Visits: 891
Here is a quick script to see the last backup for each database on the server. Gives file name (so you know where they are going), whether the database is a current database (could have been dropped in the past), and the recovery model.

Should give you an idea of the basics.



/* ========================================================================================================================== */
/* Get the very last backup set (Database and all Tranlog backups) for each database in instance */
/* ========================================================================================================================== */


CREATE TABLE #dummybackups
(
DBName varchar(300),
LastBackupDate datetime
)

CREATE TABLE #dummydb
(
DBN varchar(300),
RecMod varchar(50)
)

INSERT INTO #dummydb
SELECT name, recovery_model_desc FROM master.sys.databases
WHERE name NOT IN ('tempdb') AND is_read_only = 0 AND state = 0



INSERT INTO #dummybackups
SELECT DISTINCT database_name, NULL FROM msdb..backupset ORDER BY database_name

--Get last full backup for each database and put in dummy table for that database
UPDATE #dummybackups
SET LastBackupDate = (SELECT TOP 1 backup_start_date FROM msdb..backupset WHERE database_name = DBName AND type = 'D' ORDER BY backup_start_date DESC)

SELECT S.database_name,
CONVERT(varchar(20),'') AS CurrentDB,
S.recovery_model, S.user_name,
S.backup_start_date,
CASE WHEN CONVERT(varchar(200),GETDATE(),101) = CONVERT(varchar(200),S.backup_start_date,101) THEN '' ELSE ' * ' END AS NotFromToday,
S.type,
CONVERT(decimal(10,2),S.backup_size/1024.0/1024.0) AS backup_size_MB, M.physical_device_name
INTO #dummybackups2
FROM msdb..backupset S
JOIN msdb..backupmediafamily M ON M.media_set_id=S.media_set_id
WHERE S.backup_start_date >= (SELECT LastBackupDate FROM #dummybackups WHERE database_name = DBName) AND (S.recovery_model IS NOT NULL)
--AND S.database_name = 'somedbname'
ORDER by S.database_name, backup_start_date DESC

UPDATE #dummybackups2
SET CurrentDB = 'NO'
WHERE NOT EXISTS(SELECT name FROM master.sys.databases WHERE master.sys.databases.name = database_name)


-- insert into final resultset the databases that are in the instance, but don't have a record in the backups
INSERT INTO #dummybackups2
SELECT DBN,'',RecMod,'',NULL,'','',0,NULL FROM #dummydb WHERE DBN NOT IN (SELECT database_name FROM #dummybackups2)



SELECT *
,ISNULL(SUBSTRING(physical_device_name,1,LEN(physical_device_name) - PATINDEX('%\%',REVERSE(physical_device_name)) + 1),NULL) AS PathName
,ISNULL(SUBSTRING(physical_device_name,LEN(physical_device_name) - PATINDEX('%\%',REVERSE(physical_device_name)) + 2,PATINDEX('%\%',REVERSE(physical_device_name))-1),NULL) AS FileNm
FROM #dummybackups2 ORDER BY database_name, backup_start_date DESC


DROP TABLE #dummybackups
DROP TABLE #dummybackups2
DROP TABLE #dummydb
Post #1406002
Posted Friday, January 11, 2013 7:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 8:43 AM
Points: 37, Visits: 82
Excellent!

Thank you!


_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2
Post #1406013
Posted Friday, January 11, 2013 8:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:21 PM
Points: 1,210, Visits: 2,512
opc.three (1/11/2013)
Jamie Scharbrough (1/11/2013)
Sorry, not downloaded, I used the wrong word.

Yeah that's definitely doable (installing it on my workstation). I'm so used to everything being in the same place that I kind of panicked when I realized it wasn't there.

EDIT: Oh good grief. The original installation disks are overseas. And there would be some serious other issues in trying to get them. (The long and the short of it is, our parent company has disassociated from us and legally we are no longer allowed to work with them. It's complicated.)

Is it possible to download the 6 month freebie SSMS that Microsoft offers, or would there be issues in connecting them?

I am not sure if a SQL 2005 Evaluation download is still going to be around, but you can download the 180-day Evaluation copy of SQL 2012 from Microsoft's website and that will get you a copy of SSMS. SSMS 2012 can connect to SQL 2005 instances. You may run into some quirks trying to manage some of the subsytems (e.g. replication) but Microsoft touts that SSMS 2012 can manage SQL 2005 instances. This would only be a stopgap until you got the SQL 2005 media and could install SSMS 2005, or upgraded to SQL 2012


You can download the free SQL Server Express edition and install it on your workstation - the "with Tools" and "with Advanced Services" versions include SSMS, so be sure to get one of those and not the plain vanilla version.


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1406056
Posted Friday, January 11, 2013 8:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 8:43 AM
Points: 37, Visits: 82
It doesn't come with SQL Agent though (I'm pretty sure). I used to use it before I got the evaluation copy.

_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2
Post #1406060
Posted Friday, January 11, 2013 8:20 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:45 PM
Points: 23,081, Visits: 31,620
You can purchase SQL Server 2012 Developer Edition on Amazon.com for $43.00. Gives you everything you need for a development/training environment and doesn't cost a whole lot and you don't have to worry about it expiring.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1406066
Posted Friday, January 11, 2013 8:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 8:43 AM
Points: 37, Visits: 82
Man I wish that sucker came with two licenses though; one for work and one for home! :D

_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2
Post #1406091
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse