Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


I just became Keeper of the Ring. And I'm Boromir.


I just became Keeper of the Ring. And I'm Boromir.

Author
Message
Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8259 Visits: 14368
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
JESDBA
JESDBA
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
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

Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8259 Visits: 14368
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
JESDBA
JESDBA
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
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

vikingDBA
vikingDBA
SSC-Enthusiastic
SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)

Group: General Forum Members
Points: 198 Visits: 929
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
JESDBA
JESDBA
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 82
Excellent!

Thank you!

_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2

wolfkillj
wolfkillj
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1104 Visits: 2582
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
JESDBA
JESDBA
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
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

Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24255 Visits: 37978
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.

Cool
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)
JESDBA
JESDBA
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 82
Man I wish that sucker came with two licenses though; one for work and one for home! BigGrin

_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search