IF i uninstall SQL and reinstall it, how do I get my databases back online from my origina

Sorry, newbie here...
BJHi,
"BJ" <lmelogra@.optonline.net> wrote in message
news:uHLB458uEHA.940@.TK2MSFTNGP14.phx.gbl...
> Sorry, newbie here...
> BJ
>|||Hi,
Before Reinstall:-
1. For safe take the backup of databases
2. Detach the databases (SP_detach_db)
3. Copy the MDF and LDF to a safe location
After install
1. Apply the same service pack
2. Restore the master database
3. Restore the other database one by one or use SP_ATTCH_DB to attach the
databases
Thanks
Hari
SQL Server MVP
"BJ" <lmelogra@.optonline.net> wrote in message
news:uHLB458uEHA.940@.TK2MSFTNGP14.phx.gbl...
> Sorry, newbie here...
> BJ
>|||ok, so if I installed MS CRM which creates a few databases with the newly
created MASTER database before I did any kind of restore it fails? I did
use this which I think will work?:
Did a SQL database backup to D:\<database_1>
then loaded new SQL server.
Ran the RESTORE database option in SQL pointing it to the existing databases
on my hard drive. They show up in SQL.
But, one database we did NOT run the backup on for Goldmine. Any way to
restore that now or are we SOL?
THANKS!
BJ
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uchspB9uEHA.3200@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Before Reinstall:-
> 1. For safe take the backup of databases
> 2. Detach the databases (SP_detach_db)
> 3. Copy the MDF and LDF to a safe location
> After install
> 1. Apply the same service pack
> 2. Restore the master database
> 3. Restore the other database one by one or use SP_ATTCH_DB to attach the
> databases
>
> --
> Thanks
> Hari
> SQL Server MVP
> "BJ" <lmelogra@.optonline.net> wrote in message
> news:uHLB458uEHA.940@.TK2MSFTNGP14.phx.gbl...
> > Sorry, newbie here...
> >
> > BJ
> >
> >
>|||Hi,
Check if the MDF and LDF file exists for that database,if exits then you try
using sp_attach_db (see books onlinr) to attach the database back to sql
server.
Thanks
Hari
SQL Server MVP
"BJ" <lmelogra@.optonline.net> wrote in message
news:u5kmQG9uEHA.4020@.TK2MSFTNGP10.phx.gbl...
> ok, so if I installed MS CRM which creates a few databases with the newly
> created MASTER database before I did any kind of restore it fails? I did
> use this which I think will work?:
> Did a SQL database backup to D:\<database_1>
> then loaded new SQL server.
> Ran the RESTORE database option in SQL pointing it to the existing
> databases
> on my hard drive. They show up in SQL.
> But, one database we did NOT run the backup on for Goldmine. Any way to
> restore that now or are we SOL?
> THANKS!
> BJ
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:uchspB9uEHA.3200@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> Before Reinstall:-
>> 1. For safe take the backup of databases
>> 2. Detach the databases (SP_detach_db)
>> 3. Copy the MDF and LDF to a safe location
>> After install
>> 1. Apply the same service pack
>> 2. Restore the master database
>> 3. Restore the other database one by one or use SP_ATTCH_DB to attach the
>> databases
>>
>> --
>> Thanks
>> Hari
>> SQL Server MVP
>> "BJ" <lmelogra@.optonline.net> wrote in message
>> news:uHLB458uEHA.940@.TK2MSFTNGP14.phx.gbl...
>> > Sorry, newbie here...
>> >
>> > BJ
>> >
>> >
>>
>|||Yes they are there!! we copied this folder to another drive! Thank you!
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23OvJo79uEHA.1308@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Check if the MDF and LDF file exists for that database,if exits then you
try
> using sp_attach_db (see books onlinr) to attach the database back to sql
> server.
>
> --
> Thanks
> Hari
> SQL Server MVP
> "BJ" <lmelogra@.optonline.net> wrote in message
> news:u5kmQG9uEHA.4020@.TK2MSFTNGP10.phx.gbl...
> > ok, so if I installed MS CRM which creates a few databases with the
newly
> > created MASTER database before I did any kind of restore it fails? I
did
> > use this which I think will work?:
> >
> > Did a SQL database backup to D:\<database_1>
> >
> > then loaded new SQL server.
> >
> > Ran the RESTORE database option in SQL pointing it to the existing
> > databases
> > on my hard drive. They show up in SQL.
> >
> > But, one database we did NOT run the backup on for Goldmine. Any way to
> > restore that now or are we SOL?
> >
> > THANKS!
> >
> > BJ
> >
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> > news:uchspB9uEHA.3200@.TK2MSFTNGP14.phx.gbl...
> >> Hi,
> >>
> >> Before Reinstall:-
> >>
> >> 1. For safe take the backup of databases
> >> 2. Detach the databases (SP_detach_db)
> >> 3. Copy the MDF and LDF to a safe location
> >>
> >> After install
> >>
> >> 1. Apply the same service pack
> >> 2. Restore the master database
> >> 3. Restore the other database one by one or use SP_ATTCH_DB to attach
the
> >> databases
> >>
> >>
> >> --
> >> Thanks
> >> Hari
> >> SQL Server MVP
> >>
> >> "BJ" <lmelogra@.optonline.net> wrote in message
> >> news:uHLB458uEHA.940@.TK2MSFTNGP14.phx.gbl...
> >> > Sorry, newbie here...
> >> >
> >> > BJ
> >> >
> >> >
> >>
> >>
> >
> >
>

If I log out will SQL Server still run?

Runnning 2005. I want to log out (not reboot) of Windows Server 2003, log
in as another user, and then log out and back in as the original user. Will
doing this cause the SQL Server to stop running (taking requests from
applications)?No, assuming it is running as a service.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"HB" <replywithingroup@.notreal.com> wrote in message
news:Lws7g.6122$yM.3355@.tornado.socal.rr.com...
> Runnning 2005. I want to log out (not reboot) of Windows Server 2003, log
> in as another user, and then log out and back in as the original user.
> Will doing this cause the SQL Server to stop running (taking requests from
> applications)?
>

If I log out will SQL Server still run?

Runnning 2005. I want to log out (not reboot) of Windows Server 2003, log
in as another user, and then log out and back in as the original user. Will
doing this cause the SQL Server to stop running (taking requests from
applications)?No, assuming it is running as a service.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"HB" <replywithingroup@.notreal.com> wrote in message
news:Lws7g.6122$yM.3355@.tornado.socal.rr.com...
> Runnning 2005. I want to log out (not reboot) of Windows Server 2003, log
> in as another user, and then log out and back in as the original user.
> Will doing this cause the SQL Server to stop running (taking requests from
> applications)?
>

IE7 and RS2005 navigation issues

When I run a report under Firefox, it works fine.
If the report contains a drill through, and I drill through and then try to
back up, the report will spin and never refresh unless I manually click
refresh.
Steps to repro:
1. Create two reports, one with a drill through and the second the target
of a drill through.
2. Publish the reports.
3. Using either URL access or the report manager GUI, browse to the parent
report in IE7. Not sure if it matters, but this is on Vista.
4. From the parent report, drill through to the child report.
5. Using any of the various ways to navigate backwards, backup to the
parent report. The report will spin and never resolve.
Is this a configuration issue on my end or is this an IE7 issue? I've tried
various browser options and I get this behavior no matter what. It works
fine in Firefox and Opera.
Thanks,
JustinHello Justin,
I would like to know whether you have add your server into the trust area
and enabled the javascript.
I tested on my Vista machine and I could drillthrough and backwards
correctly.
Please let me know if you still could not navigate the report.
Thanks!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei,
Thank you for fielding this.
I've tried various IE7 security settings, including setting it to low and
protection mode to off.
I did a bit more research and here's what I see.
1. When you drill through to the subreport, it loads fine.
2. When you hit back and check the URL of the iframe for the
reportview.axd, the parameter information is gone.
It still has the report the target in the query string, but parameters have
been lost.
Note - I am running without default parameters.
Perhaps you could try and use a drill through that requires parameters and
let me know if you can reproduce it.
Thanks,
Justin
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:nFvYtABfHHA.4368@.TK2MSFTNGHUB02.phx.gbl...
> Hello Justin,
> I would like to know whether you have add your server into the trust area
> and enabled the javascript.
> I tested on my Vista machine and I could drillthrough and backwards
> correctly.
> Please let me know if you still could not navigate the report.
> Thanks!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Justin,
I would like to know where did you view the report? Direct in IE to view
the reports on Report Server? Or are you using the Sharepoint Web Part to
view the report?
Also, what did you use to drillthough the report. Jump to Report or Jump to
URL?
I tested the child report with paremeter which still could drillthrough
correctly.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||On Apr 12, 5:10 am, w...@.online.microsoft.com (Wei Lu [MSFT]) wrote:
> Hello Justin,
> I would like to know where did you view the report? Direct in IE to view
> the reports on Report Server? Or are you using the Sharepoint Web Part to
> view the report?
> Also, what did you use to drillthough the report. Jump to Report or Jump to
> URL?
> I tested the child report with paremeter which still could drillthrough
> correctly.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
I am having the exact same issue with any drilldown reports. When I
try to go back to the parent report, it just spins and never
resolves. If I hit the refresh button, then it resolves. Has anyone
figured out what this issue is?
Thanks,
Scott|||I also have the same problem. I have a three layer report in which the drill
downs are just fine but the IE7 Back button leaves me spinning forever. The
project runs fine in the designer. At this stage of development, I am running
locally so there should not be any network problem.
Any assistance would be greatly appreciated.
Thanks
Dennis
"scott.hunley@.cox.net" wrote:
> On Apr 12, 5:10 am, w...@.online.microsoft.com (Wei Lu [MSFT]) wrote:
> > Hello Justin,
> >
> > I would like to know where did you view the report? Direct in IE to view
> > the reports on Report Server? Or are you using the Sharepoint Web Part to
> > view the report?
> >
> > Also, what did you use to drillthough the report. Jump to Report or Jump to
> > URL?
> >
> > I tested the child report with paremeter which still could drillthrough
> > correctly.
> >
> > Sincerely,
> >
> > Wei Lu
> > Microsoft Online Community Support
> >
> > ==================================================> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> >
> > ==================================================> > This posting is provided "AS IS" with no warranties, and confers no rights.
>
> I am having the exact same issue with any drilldown reports. When I
> try to go back to the parent report, it just spins and never
> resolves. If I hit the refresh button, then it resolves. Has anyone
> figured out what this issue is?
> Thanks,
> Scott
>

IE 7 RC 1 does not respond to Back history command while viewing a report

I have noticed a minor problem in IE 7 RC 1, while viewing a Microsoft
Reporting Services report the Back history command does not work.
Thanks,
Lonyes - I saw this too - I just now load RC 1 now thinking my older version
just had the problem.
Really bites - you think many would have noticed this on their end already.
"Lon" <lonuel@.gmail.com> wrote in message
news:1157478836.906147.116200@.d34g2000cwd.googlegroups.com...
>I have noticed a minor problem in IE 7 RC 1, while viewing a Microsoft
> Reporting Services report the Back history command does not work.
> Thanks,
> Lon
>sql

Identity ranges different for different pubs

Silly question that came to mind as I was driving back from a poker game:
What would happen if one publication sets an identity range at say, 100,000
and another publication (in the same database) has the identity range set
for 50,000 on the same table?
Earl,
when you create the second publication, the identity range for the table is
inherited from the first one.
If you're having these sort to thoughts, does it mean you won or lost ?
Rgds,
Paul Ibison, SQL MVP
|||Hehe. I won... now if I can just cobble together enough wins to get back to
the WSOP this year ...
On a more serious note, I'm in the final stages of rolling out an app and
when the mind is freewheeling, I tend to speculate on what might go wrong
long-term. It seems like some issues of replication could lead to walking
into a dead-end if it were not anticipated early on.
Thanks Paul.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eGNf8mBcFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Earl,
> when you create the second publication, the identity range for the table
> is inherited from the first one.
> If you're having these sort to thoughts, does it mean you won or lost ?
> Rgds,
> Paul Ibison, SQL MVP
>

Identity Increment

If delete all the records from a table that has an incremental identity. Is there a TSQL way of reset the first number on an insert back to be 1 again without going to the table taking it off then saving it the putting it back on again?TRUNCATE table clears all data and resets the Identity counter.|||Perfect! Thank you.

Identity Column Rollover

If I have an Identity column defined as a smallint
seed=1, increment=1
Does it automatically roll back to 1 when the number of records reaches
32,767. Assuming of course, the last record assigned identity 1 has been
removed.
I assume it does, but hey, I've assumed stuff like this before and gotten
burned.
JohnNo it does not automatically roll over. Instead you will receive an
overflow error and future inserts will fail. You could then reseed the
value using the DBCC CHECKIDENT command. A much better plan however, is
to create the column large enough that it won't overflow for the
forseeable future.
David Portas
SQL Server MVP
--|||No, you assume wrong. You'll get an error when you try to insert a new row.
"Arithmetic overflow error for data type smallint, value = 32768"
Change to Int if you believe that it may be a problem.
"John Manion" <JohnManion@.discussions.microsoft.com> wrote in message
news:785FF58A-2C96-4AAF-9E2A-30C918853DDE@.microsoft.com...
> If I have an Identity column defined as a smallint
> seed=1, increment=1
> Does it automatically roll back to 1 when the number of records reaches
> 32,767. Assuming of course, the last record assigned identity 1 has been
> removed.
> I assume it does, but hey, I've assumed stuff like this before and gotten
> burned.
> John|||No. SQL Server will try to increment the identity value and also give you an
error when trying to store the new value.
Example:
use northwind
go
create table t (
colA smallint not null identity
)
go
set identity_insert t on
go
insert into t (colA) values(32767)
go
set identity_insert t off
go
select * from t
go
insert into t default values
go
select * from t
go
drop table t
go
AMB
"John Manion" wrote:

> If I have an Identity column defined as a smallint
> seed=1, increment=1
> Does it automatically roll back to 1 when the number of records reaches
> 32,767. Assuming of course, the last record assigned identity 1 has been
> removed.
> I assume it does, but hey, I've assumed stuff like this before and gotten
> burned.
> John|||Not surprising.
Thanks,
John
"David Portas" wrote:

> No it does not automatically roll over. Instead you will receive an
> overflow error and future inserts will fail. You could then reseed the
> value using the DBCC CHECKIDENT command. A much better plan however, is
> to create the column large enough that it won't overflow for the
> forseeable future.
> --
> David Portas
> SQL Server MVP
> --
>

Identity Column Null? WHAT?

Hey all
Wanted to check the identity of my column so I ran this:
dbcc checkident (tablename)
It came back saying it was null!!!
"Checking identity information: current identity value 'NULL', current
column value 'NULL'."
What gives? When I enter a value in the column...it starts with 0. I want it
to start with 1!!! Any suggestions? I already tried reseeding it and it still
says null grrrr.
Thanks
Theresa
> What gives? When I enter a value in the column...it starts with 0. I want
> it
> to start with 1!!! Any suggestions?
Drop the table and create it correctly?
CREATE TABLE dbo.MyTable
(
IdentityColumn INT NOT NULL IDENTITY(1,1)
--, ... other columns
);
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23TiZk$RXHHA.4480@.TK2MSFTNGP04.phx.gbl...
> Drop the table and create it correctly?
> CREATE TABLE dbo.MyTable
> (
> IdentityColumn INT NOT NULL IDENTITY(1,1)
> --, ... other columns
> );
>
And people wonder why Celko hates IDENTITY so much. :-)

> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

Identity Column Null? WHAT?

Hey all
Wanted to check the identity of my column so I ran this:
dbcc checkident (tablename)
It came back saying it was null!!!
"Checking identity information: current identity value 'NULL', current
column value 'NULL'."
What gives? When I enter a value in the column...it starts with 0. I want it
to start with 1!!! Any suggestions? I already tried reseeding it and it stil
l
says null grrrr.
Thanks
Theresa> What gives? When I enter a value in the column...it starts with 0. I want
> it
> to start with 1!!! Any suggestions?
Drop the table and create it correctly?
CREATE TABLE dbo.MyTable
(
IdentityColumn INT NOT NULL IDENTITY(1,1)
--, ... other columns
);
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:%23TiZk$RXHHA.4480@.TK2MSFTNGP04.phx.gbl...
> Drop the table and create it correctly?
> CREATE TABLE dbo.MyTable
> (
> IdentityColumn INT NOT NULL IDENTITY(1,1)
> --, ... other columns
> );
>
And people wonder why Celko hates IDENTITY so much. :-)

> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

Identity Column Null? WHAT?

Hey all
Wanted to check the identity of my column so I ran this:
dbcc checkident (tablename)
It came back saying it was null!!!
"Checking identity information: current identity value 'NULL', current
column value 'NULL'."
What gives? When I enter a value in the column...it starts with 0. I want it
to start with 1!!! Any suggestions? I already tried reseeding it and it still
says null grrrr.
Thanks
Theresa> What gives? When I enter a value in the column...it starts with 0. I want
> it
> to start with 1!!! Any suggestions?
Drop the table and create it correctly?
CREATE TABLE dbo.MyTable
(
IdentityColumn INT NOT NULL IDENTITY(1,1)
--, ... other columns
);
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23TiZk$RXHHA.4480@.TK2MSFTNGP04.phx.gbl...
>> What gives? When I enter a value in the column...it starts with 0. I want
>> it
>> to start with 1!!! Any suggestions?
> Drop the table and create it correctly?
> CREATE TABLE dbo.MyTable
> (
> IdentityColumn INT NOT NULL IDENTITY(1,1)
> --, ... other columns
> );
>
And people wonder why Celko hates IDENTITY so much. :-)
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com