Friday, March 30, 2012

HELP!...VB.NET killed SQL Server

Hi,
Yesterday I installed VB.NET on my machine. I had been runnng SQL Server
2000. After the install SQL Server will not run. SQLAgent fails with the
error "1068: The dependency service or group failed to start". When I try to
start MSSQL service I get a message it started then stopped because it may
not have anything to do.
I was planning to install SP3 of SQL Server 2000, so I tried that, but it
fails to install because (it seems) it needs SQL Server to be running.
Any ideas? Right now I desperately need SQL Server but not VB. So, I
guess my next move is to un-install VB.NET, which is going to be a royal
pain, and that may not even work because such a big install cannot be truly
uninstalled. After that I would fall back to an OS restore point.
Help, please!
Tim
> When I try to
> start MSSQL service I get a message it started then stopped because it may
> not have anything to do.
Can you post the SQL Server errorlog file? Assuming it is only a few rows, of course...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim" <Tim@.discussions.microsoft.com> wrote in message
news:D3C2B8A5-17F9-448D-8EA0-19F5A4119907@.microsoft.com...
> Hi,
> Yesterday I installed VB.NET on my machine. I had been runnng SQL Server
> 2000. After the install SQL Server will not run. SQLAgent fails with the
> error "1068: The dependency service or group failed to start". When I try to
> start MSSQL service I get a message it started then stopped because it may
> not have anything to do.
> I was planning to install SP3 of SQL Server 2000, so I tried that, but it
> fails to install because (it seems) it needs SQL Server to be running.
> Any ideas? Right now I desperately need SQL Server but not VB. So, I
> guess my next move is to un-install VB.NET, which is going to be a royal
> pain, and that may not even work because such a big install cannot be truly
> uninstalled. After that I would fall back to an OS restore point.
> Help, please!
> Tim
|||Thanks! I ran the SQL Server setup program with the option "Rebuild
Registry" and now it seems fine. Thanks again!
Tim
"Tibor Karaszi" wrote:

> Can you post the SQL Server errorlog file? Assuming it is only a few rows, of course...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tim" <Tim@.discussions.microsoft.com> wrote in message
> news:D3C2B8A5-17F9-448D-8EA0-19F5A4119907@.microsoft.com...
>
>

help!...sp1 or sp2

After I install SP1 of SP2 for reporting services, I get the following
error:
The version of the report server database is either in a format that is
not
valid, or it cannot be read. The found version is 'C.0.6.54'. The
expected
version is 'C.0.6.43'. To continue, update the version of the report
server
database and verify access rights. (rsInvalidReportServerDatabase)
I am currently running RS enteprise edition with SQL server 2000
Standard edition.
When I used to have RS std. edition with SQL server 2000 std.edition,
I've applied both service packs and didn't get the error.
Can you help me with this problem?
Thanks,If you already installed SP2, you can not install SP1 afterwards and
you do not need to.
Service Packs are cumulative - they contain everything from prior
service packs.
bevarg wrote:
> After I install SP1 of SP2 for reporting services, I get the following
> error:
> The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'C.0.6.54'. The
> expected
> version is 'C.0.6.43'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)
> I am currently running RS enteprise edition with SQL server 2000
> Standard edition.
> When I used to have RS std. edition with SQL server 2000 std.edition,
> I've applied both service packs and didn't get the error.
> Can you help me with this problem?
> Thanks,

HELP!... SQL Log Gone. How do I recover Database

As the subject says...
I will admit to some stupidity. I inadvertently deleted
the log file.
On top of that, it appears my backups have failed, so no
back up.
Data file still exists.
Please tell me there is a way to recover.
Thanks in advance.
SvenI would give MS PSS a call if it's important to get it back.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
But if all else fails here is something you can try:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
Andrew J. Kelly
SQL Server MVP
"Sven Hansen" <svenhansen@.shaw.ca> wrote in message
news:079001c3af02$a07d2fa0$a101280a@.phx.gbl...
> As the subject says...
> I will admit to some stupidity. I inadvertently deleted
> the log file.
> On top of that, it appears my backups have failed, so no
> back up.
> Data file still exists.
> Please tell me there is a way to recover.
> Thanks in advance.
> Sven|||If you have the data file, then you can bring back your
database by using "sp_attach_db" coomand.
Look in BOL, for syntax and more info. Its very easy.
Good Luck!
-SQLVarad (MCDBA-1999,MCSE-1999)
>--Original Message--
>As the subject says...
>I will admit to some stupidity. I inadvertently deleted
>the log file.
>On top of that, it appears my backups have failed, so no
>back up.
>Data file still exists.
>Please tell me there is a way to recover.
>Thanks in advance.
>Sven
>.
>|||Since you have only data file, use this syntax
Example:
EXEC sp_attach_db @.dbname = 'pubs',
'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
SQL Server will automatically attach a new log file.
Good Luck!
SQLVarad (MCDBA-1999,MCSE-1999)
>--Original Message--
>As the subject says...
>I will admit to some stupidity. I inadvertently deleted
>the log file.
>On top of that, it appears my backups have failed, so no
>back up.
>Data file still exists.
>Please tell me there is a way to recover.
>Thanks in advance.
>Sven
>.
>|||You saved my life... and likely my job... :)
Thank you.
The script worked perfectly.
Take care and thanks again.
Sven
>--Original Message--
>I would give MS PSS a call if it's important to get it
back.
>http://support.microsoft.com/default.aspx?scid=fh;EN-
US;sql SQL Support
>http://www.mssqlserver.com/faq/general-pss.asp MS PSS
>But if all else fails here is something you can try:
>http://www.sqlservercentral.com/scripts/scriptdetails.asp
?scriptid=599
>Restoring a .mdf
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Sven Hansen" <svenhansen@.shaw.ca> wrote in message
>news:079001c3af02$a07d2fa0$a101280a@.phx.gbl...
>> As the subject says...
>> I will admit to some stupidity. I inadvertently
deleted
>> the log file.
>> On top of that, it appears my backups have failed, so
no
>> back up.
>> Data file still exists.
>> Please tell me there is a way to recover.
>> Thanks in advance.
>> Sven
>
>.
>

Help!. Images not Displaying

Hello
i have made a report and inserted some company logo in the report header ,,,
from the image wizard i selected Embeded type ,, But when i run the port in
asp.net by calling its webservice ,,,images are not shown.
Plz help me to solve this problem
ThanksHi Malik,
Please look at following link. "_" in the machine name may be the
culprit. Use the IP instead of machine name. Also replace machine name in
report server and report manager config files with machine IP address.
http://groups.google.com.pk/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/dc1fcfec0c41ec70/23425c9cbdabb2a1?q=%22reporting+services%22+%2B+%22images%22&rnum=1&hl=en#23425c9cbdabb2a1
"Malik Asif Joyia" wrote:
> Hello
> i have made a report and inserted some company logo in the report header ,,,
> from the image wizard i selected Embeded type ,, But when i run the port in
> asp.net by calling its webservice ,,,images are not shown.
> Plz help me to solve this problem
> Thanks
>
>sql

HELP!!-Urgent

"I've created a customer table and I want to give each customer a
unique id e.g 'ES001' But sql server won't let me I've looked at
various books to no avail.

My second question is when I delete a row from a table which had an ID
of 2 when I put in a new row it gives the new row and ID of 3 how do i
make it give the row an ID of 2."You can use a view, trigger or a calculated column to derive a
meaningful surrogate key from your data, or you can generate it in your
application. What exactly do you have a problem with? What do you mean
by "sql server won't let me"?

As for your second question, the whole point of an IDENTITY key (I
assume that's what you are referring to) is that it is internal,
auto-generated and meaningless. If you care about what the value should
be then you shouldn't use IDENTITY. If you are just trying to number
each row then why put that information in the table at all - just
display the numbers when you query it or print a report.
--
David Portas
SQL Server MVP
--|||Salim (s_aboobaker@.hotmail.com) writes:
> "I've created a customer table and I want to give each customer a
> unique id e.g 'ES001' But sql server won't let me I've looked at
> various books to no avail.

CREATE TABLE customers (id char(5) NOT NULLL,
...
CONSTRAINT pk_customers PRIMARY KEY (id))
go
INSERT customers (id, ...)
VALUES ('ES001', ...

> My second question is when I delete a row from a table which had an ID
> of 2 when I put in a new row it gives the new row and ID of 3 how do i
> make it give the row an ID of 2."

INSERT tbl (id, ...)
VALUES (2, ...)

As David said, don't use IDENTITY if you want to specify the key values
yourself.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Ehere to begin? You are doing everything wrong because you do not
understand the basic concepts of RDBMS. A table is not a file; it
models an entity in reality. To find a unique identifier, you need to
look at your data model.

**by definition** the IDENTITY extension in T-SQL can never be a key.
It is a sequential numbering that id derived from the state of the
hardware at the time of insertion. It has nothing whatsoever to do
with your data model or the reality being modelled.

What you have is a file system written in SQL. We used to re-use fixed
length preallocated records in a lot of the early disk OS, just like
you are trying to do.

Please get a book on the basics before you learn all the kludges that
people will give you and learn to do it right.|||--CELKO-- (jcelko212@.earthlink.net) writes:
> Ehere to begin? You are doing everything wrong because you do not
> understand the basic concepts of RDBMS. A table is not a file; it
> models an entity in reality. To find a unique identifier, you need to
> look at your data model.
> **by definition** the IDENTITY extension in T-SQL can never be a key.
> It is a sequential numbering that id derived from the state of the
> hardware at the time of insertion. It has nothing whatsoever to do
> with your data model or the reality being modelled.

Where do you get all the crap from?

This is the original post?

"I've created a customer table and I want to give each customer a
unique id e.g 'ES001' But sql server won't let me I've looked at
various books to no avail.

My second question is when I delete a row from a table which had an ID
of 2 when I put in a new row it gives the new row and ID of 3 how do i
make it give the row an ID of 2."

No talk of IDENTITY, no talk about files. In fact it is obvious that
ES001 has nothing to do with IDENTITY.

> What you have is a file system written in SQL. We used to re-use fixed
> length preallocated records in a lot of the early disk OS, just like
> you are trying to do.
> Please get a book on the basics before you learn all the kludges that
> people will give you and learn to do it right.

All I can say to unexperienced people who are following this group is
to put Joe Celko in your kill files. He can't read the posts he replies
to properly. He repeats misconceptions about SQL Server all over again.
His examples are full of sloppy errors. His tone against unexperienced
users is unacceptable.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||s_aboobaker@.hotmail.com (Salim) wrote in news:d84b91a3.0501280315.1f9a13c4
@.posting.google.com:

> "I've created a customer table and I want to give each customer a
> unique id e.g 'ES001' But sql server won't let me I've looked at
> various books to no avail.
> My second question is when I delete a row from a table which had an ID
> of 2 when I put in a new row it gives the new row and ID of 3 how do i
> make it give the row an ID of 2."

Somebody's not getting their money's worth out of *this* consultant.

HELP!!-Jump to URL

I input for "Jump to URL".
But I don't want to open URL on same page.
Is it possible to open new window for that URL page after click one which
have a "Jump to URL".Yes it is, something like this:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?%2fJBOSC%2fJLRRS%2fworkorder%2fwondetail&WON=" & Fields!COL2.Value &
"','_blank'))"
"Ken" wrote:
> I input for "Jump to URL".
> But I don't want to open URL on same page.
> Is it possible to open new window for that URL page after click one which
> have a "Jump to URL".
>
>

HELP!!:about the MS association rules

When i use the MS association rules ,i don't know how it is worked on the background .I stuy the Fp-Growth algorithm , but there're some questions , I don't kown what's the meaning of transcation database. who can give me one example ? thanks .I know we can store the data in relation database,but in basket Analysis ,how a transaction stroed in relation database?

In the context of Association Rules/Market Basket Analysis, we are talking about the contents of the "basket" when we refer to the transaction table. In a relational database, you'd typically have a master table containing information about customers (for instance) and a detail table that has a foreign key relationship with the master table and holds the associated purchases for each customer.

The more common approach for market basket analysis is to model each transaction (containing multiple items) as a case so your transaction table would have a composite key comprising the transaction id and item id, with multiple rows for each transaction id, comprising all items that were bought together as part of that single transaction. From the point of view of SQL Data Mining, you would use the same table as the "case table" as well as the "nested table" containing the associated items for each transaction.

See this article for an example: http://www.aspnetpro.com/newsletterarticle/2004/10/asp200410ri_l/asp200410ri_l.asp.

|||

hi, Raman Iyer ,your answer is helpful for me,thanks .This problem I had resoved several days ago ,but when i looked at the article your offerd for me, i also got much help.thank you.

there is another problem in my study, I had write the Fp_Growth algorithm, and had got the Fp itemsets ,but when i wanted to display these itemsets into association rules , i met the problem. I stored the itemsets in relation database,for example :

ItemsetsID

Itemid

itemsetsCount

1

I1

3

1

I2

3

2

I1

4

2

I3

4

3

I1

3

3

I2

3

3

I3

3

4

I2

3

4

I3

3

……………

…………

……………

it means there're 4 itemset (I1,I2 : 3),(I1,I3 :4 ),(I2,I3 : 3 )and(I1,I2,I3 : 3),and the |D|=10(|D|means the num of the transaction )

Count(I1)=7

Count(I2)=6

Count(I3)=7

Count(I1,I2)=3

Count(I1,I3)=4

Count(I1,I2,I3)=3

Count(I2,I3)=3

so i want to get the rules like this ,

Interesting = support(left+right)/(support(left)*support(right))

Ruleid

Left

Right

Support

Confidence

Interesting

1

I1

I2

0.3

3/7

0.3/(0.7*0.7)

2

I2

I1

0.3

3/6

0.3/(0.7*0.6)

3

I1

I3

0.4

4/7

0.4/(0.7*0.7)

4

I3

I1

0.4

4/7

0.4/(0.7*0.7)

5

I1

I2,I3

0.3

3/7

0.3/(0.7*0.3)

6

I2

I1,I3

0.3

3/6

0.3/(0.6*0.4)

7

I3

I1,I2

0.3

3/7

0.3/(0.7*0.3)

8

I1,I2

I3

0.3

3/3

0.3/(0.3*0.7)

9

I1,I3

I2

0.3

3/4

0.3/(0.4*0.6)

10

I2,I3

I1

0.3

3/3

0.3/(0.3*0.7)

11

I2

I3

0.3

3/6

0.3/(0.6*0.7)

12

I3

I2

0.3

3/7

0.3/(0.7*0.6)

what the type can i store the rule in my relation database , just like the table 2? and what's the tool or technology can i use to display these rules in my webpage , owc?or reporting service? Are there any article that i shoud read , can you give me some advice? thank you

help!!!求救!!!

Application Log: Event ID 17311
SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).

Message
[012] The MSSQL$DATAPROSQL service terminated unexpectedly

please please who can tell me why and how to ?

事件类型: 错误
事件来源: MSSQLSERVER
事件种类: (2)
事件 ID: 17311
日期: 2006-8-19
事件: 11:10:47
用户: N/A
计算机: TXOA
描述:
由于出现异常 c0000005,SQL Server 正在终止。此错误可能是由未处理的 Win32 或 C++ 异常造成的,也可能是因在处理异常过程中遇到的违规访问引起的。请查看 SQL 错误日志,获取任何相关的堆栈转储或消息。此异常会强制 SQL Server 关闭。要从此错误中恢复,请重新启动服务器(除非已将 SQLAgent 配置为自动重新启动)。
数据:
0000: 9f 43 00 00 10 00 00 00 ?C......
0008: 05 00 00 00 54 00 58 00 ....T.X.
0010: 4f 00 41 0

这里有没有微软中国的大侠啊,这个问题是到底怎么回事啊,在sql2000时,打sp3补丁可以解决,可是sql2005的sp1补丁我打了也没有解决啊,更奇怪的是,为什么我在“服务”中设置了sqlserver的故障恢复为“重新启动”也不执行呢???

我的数据库服务器配置是cpu:intel 至强 2.4×4,RAM:1GB,OS:MSWindows 2000 Advance Server

哪位大侠能告诉我这到底是为什么和怎么解决啊???

I think this might be a 'server guy' problem. It sounds like this is a windows issue.

You will probably need to work in tandem with that person to diagnose, if it keeps happening. Make sure your disks are good, RAM is good, etc. Think about rebuilding if it keeps happening.

Microsoft can read the dump for you, and there are switches, I believe, that you can set to make sure you get specific dump logs. If you are desperate and don't want to ask them, there are applications (some from them, I think) that can read a windows dump file.

|||Fatal exception tends to be a bug. I suggest you contact MS technical support.

Help!!!SOS!!!

Now,in a matrix, When the mouse transfers to an report item or single-clicks an report item , displays more informationan about the report item (for example ,an report item displays an employee's ID,when transfers to the report item or single-clicks the report item , displays the employee's sex)What should i do?|||It sounds like you want to use a drillthrough action. Build another report that is parameterized by the groups of your matrix and specify a drillthrough action with the clicked on values.sql

Help!!!SOS!!!

Now,in a matrix, When the mouse transfers to an report item or single-clicks an report item , displays more informationan about the report item (for example ,an report item displays an employee's ID,when transfers to the report item or single-clicks the report item , displays the employee's sex)What should i do?|||It sounds like you want to use a drillthrough action. Build another report that is parameterized by the groups of your matrix and specify a drillthrough action with the clicked on values.

Help!!!Cannot connect to remote sql server by named pipe

Hi, all,

I installed sql server 2005 express on a server with window server 2003 SP1 and tried to connect it from a remote computer with vista installed.

I have already enabled named pipe and tcp/ip protocol for instance SQLEXPRESS on the server, and started sql server browser as well. Of course, I also enabled local and remote connection using tcp/ip and named pipe by sql server surface area configuration tool.

In this senario, I can connect to server locally or remotely by tcp/ip and connect to server locally by named pipe(c>sqlcmd -S \\192.168.1.100\pipe\MSSQL$SQLEXPRESS\sql\query -U * -P *), but I can not connect to server remotely using same command line.

According to some article from MSDN, it might be caused by firewall, but I already disabled my firewall. Moreover, I used tools like makepipe.exe and readpipe.exe, they didn't work too. Why the 2 computers can't create connection using named pipe protocol.

Thanks.

Johonson Chan

By "remotely" what do you mean? Are you talking a VPN or across the Internet?

You do not want to run named pipes across the Internet for many reasons. Named pipes use TCP port 445. Across the Internet you are subject to firewall in all the routers in between the 2 computers.

Use TCP/IP.

|||

I'm having a similar issue. As far as I can tell, all the configuration is set up correctly. The remote connection is enabled, TCP/IP is enabled, firewall is turned off. I'm trying to connecto to a database on a remote server using Sharepoint desinger and always get an error message saying 'The data retrieval service encountered an error during connection to the data source'.

Anyone had a luck with using the database connection feature in the Sharepoint designer?

Thanks.

|||

I am also having a simliar issue. Running sql server 2005, trying to connect using crystal reports 8.5, get error 'unable to connect to sql server <server name>' when connecting from a machine running windows server 2003 service pack 1.

The strange this is that it connects fine when I connect using the same crystal report, version 8.5 from my PC running Windows XP service Pack 2, so it means that the sql server 2005 is configured correctly.

I can connect to the server using ODBC on the windows server 2003 machine - just not through the crystal report.

Anyone else had this issue? Or any ideas how I can solve it?

Thanks.

|||I'm having a problem too. I can connect to SQL Server 2k5 via TCP/IP on all my WinXP machines, but my WinVista machine fails. I am also not using Windows authentication because I am connecting via the Intnernet, and will not be using Windows domains.

-Simon
|||

same problem trying to connect over the internet to sql server 2005 using sql server authentication .

the client is sql server 2005 and is running on vista. it worked fine from my xp box. this problem is killing me at the moment.

tcp/ip is enabled and i've tried it with and without the firewalls. aarrrrrrrrrrrrrrrrrrrggggggggggggggghhhhhhhhhhhhhhhhhhhhhhhhhhhhh


Login failed for user 'xxxxxxxx'. (.Net SqlClient Data Provider)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476


Server Name: xxxxxxxxxxx,1433
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

Help!!!Cannot connect to remote sql server by named pipe

Hi, all,

I installed sql server 2005 express on a server with window server 2003 SP1 and tried to connect it from a remote computer with vista installed.

I have already enabled named pipe and tcp/ip protocol for instance SQLEXPRESS on the server, and started sql server browser as well. Of course, I also enabled local and remote connection using tcp/ip and named pipe by sql server surface area configuration tool.

In this senario, I can connect to server locally or remotely by tcp/ip and connect to server locally by named pipe(c>sqlcmd -S \\192.168.1.100\pipe\MSSQL$SQLEXPRESS\sql\query -U * -P *), but I can not connect to server remotely using same command line.

According to some article from MSDN, it might be caused by firewall, but I already disabled my firewall. Moreover, I used tools like makepipe.exe and readpipe.exe, they didn't work too. Why the 2 computers can't create connection using named pipe protocol.

Thanks.

Johonson Chan

By "remotely" what do you mean? Are you talking a VPN or across the Internet?

You do not want to run named pipes across the Internet for many reasons. Named pipes use TCP port 445. Across the Internet you are subject to firewall in all the routers in between the 2 computers.

Use TCP/IP.

|||

I'm having a similar issue. As far as I can tell, all the configuration is set up correctly. The remote connection is enabled, TCP/IP is enabled, firewall is turned off. I'm trying to connecto to a database on a remote server using Sharepoint desinger and always get an error message saying 'The data retrieval service encountered an error during connection to the data source'.

Anyone had a luck with using the database connection feature in the Sharepoint designer?

Thanks.

|||

I am also having a simliar issue. Running sql server 2005, trying to connect using crystal reports 8.5, get error 'unable to connect to sql server <server name>' when connecting from a machine running windows server 2003 service pack 1.

The strange this is that it connects fine when I connect using the same crystal report, version 8.5 from my PC running Windows XP service Pack 2, so it means that the sql server 2005 is configured correctly.

I can connect to the server using ODBC on the windows server 2003 machine - just not through the crystal report.

Anyone else had this issue? Or any ideas how I can solve it?

Thanks.

|||I'm having a problem too. I can connect to SQL Server 2k5 via TCP/IP on all my WinXP machines, but my WinVista machine fails. I am also not using Windows authentication because I am connecting via the Intnernet, and will not be using Windows domains.

-Simon
|||

same problem trying to connect over the internet to sql server 2005 using sql server authentication .

the client is sql server 2005 and is running on vista. it worked fine from my xp box. this problem is killing me at the moment.

tcp/ip is enabled and i've tried it with and without the firewalls. aarrrrrrrrrrrrrrrrrrrggggggggggggggghhhhhhhhhhhhhhhhhhhhhhhhhhhhh


Login failed for user 'xxxxxxxx'. (.Net SqlClient Data Provider)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476


Server Name: xxxxxxxxxxx,1433
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

Help!!!!--Problems about the multi column report!

I have a 2 coulmns report ,one group ,when I print the report,it does not paging correctly.For example,suppose every column can display 20 rows, if every group has 20-40 rows ,the print is ok,it can paging correctly,but if one group has 10 rows or more than 40 and less than 60,the two groups will print on one paper,how can I print the every group on different paper?

Any advice would be much appreciated.

Thanks.

No one can answer me?|||

Garlic,

You can edit your group properties, On your group, right click, select edit group, on General tab, select "Page break at start" this should give you a new page for each group change.

Help!!!! Restore file mdf after exec "Drop table..." to previous state.

Hi all.
First, sorry about my poor english.

I have a database which above 6 gb data and i have droped all table in my database.
I try to restore from log file but my database is set to simple backup and auto shrink so log file doesn't help anymore.
I have used some software to recovery from log file too but useless.
My only hope right now is mdf file.
Please help me. How could i restore my mdf file to state before i droped tables.
Thanks

Since you are in simple recovery model, you can't use transaction log backups and none of the recovery tools on the market will be able to help since they rely on the contents of the transaction log to get the data back. If you don't have a backup of the database, the data is gone.

|||

There is actually a VERY brute force way that you really aren't going to like. Dropping objects in SQL Server works very similar to deleting a file on the operating system. You don't actually wipe out the file, you just remove an 8 byte header that essentially says "I'm a valid file". In SQL Server, you remove the object from the SQL Server metadata. Once the entries for the object have been removed from sysindexes, SQL Server will no longer find the data. Unless you have done something to reallocate those pages to another object in which case everything will be wiped out on that page, you can actually get to the raw pages. This is NOT pretty. You can use the DBCC PAGE command to read a page. You would wind up running this one page at a time and extracting the data from each page as you go. Then you would have to reconstruct everything and manually reload the data. (Did I mention, you REALLY don't want to have to do this which is why you always take frequent backups.)

So, step 1 in this process is to immediately create a backup of the database. Step 2 is to immediately put a backup plan in place so that the database is being backed up on a routine basis. Then you can use the following set of commands to manually extract the data. Below is an example. You would substitute your database name. You would then start at file = 1 and page = 1 and incrementally walk through page 2, 3, 4, ... and then repeat the process for any other files present in the database. The final step in the process would be to test your backup strategy and continue to test it on a frequent basis. (If you don't keep a backup of a database, you are basically saying that it is unimportant and you don't care about losing it.)

--dbcc page ( {'dbname' | dbid}, filenum, pagenum [, printopt={0|1|2|3} ])

dbcc traceon (3604)

dbcc page (pubs,1,88,3)

go

|||Thanks very much.
As you mentioned, i try to use DBCC PAGE and it has a lot of thing which i don't understand.
Please show me the way to read info from what DBCC Page return and meaning of those.
Thanks again.|||You are reading the raw storage on a page using this command. It is easier to just point you at a book. Go out and pick up a copy of "Inside SQL Server 2000" by Kalen Delaney. There are about 100 pages of material that relate back to interpreting and utilizing the output from DBCC PAGE.|||I will read it and find what i can do with that book.
You help me very much, thanks. :)|||BTW, the DBCC PAGE command is an undocumented command which means it is not supported by Microsoft (but nobody is stopping you from not using them). Try Googling around for some references on these undocumented commands, stored procedures and functions and you will find a lot of useful ones.|||I have read the book which you mentioned. I try to find out exactly what you mean when you said i can read pages in mdf file one by one but i don't get it.
Could you tell me which tools or language or anything else to perform that idea.
Thanks|||

If you query sysfiles within a database, you get the list of FileIDs. In general, if you have an mdf file, it will be fileID = 1.

So you use DBCC page to read each page manually by doing the following:

1. Open a query window.

2. Execute:

DBCC TRACEON(3604)

DBCC PAGE(<database name>,1,1,3)

3. Read the contents of the page and extract any data that you need

4. Execute:

DBCC TRACEON(3604)

DBCC PAGE(<database name>,1,2,3)

5. Read the contents of the page and extract any data that you need

6. Execute:

DBCC TRACEON(3604)

DBCC PAGE(<database name>,1,3,3)

7. Read the contents of the page and extract any data that you need

8. Execute:

DBCC TRACEON(3604)

DBCC PAGE(<database name>,1,4,3)

Etc. There isn't any tool to do this. You do this in Transact-SQL. Like I said when I brought this up, this is an absolute last resort if you can access the database, it is EXTREMELY ugly, EXTREMELY resource intensive, and EXTREMELY time consuming. Why, because you pull page 1, then page 2, then page 3, then page 4, then page 5, then.... until you get an error message that the page doesn't exist. Even in a small database, you can have hundreds or thousands of pages, so that means that in even a small database, you would have to execute DBCC PAGE hundreds or thousands of times, read the contents of the page, and manually extract the data. In production databases, you can easily have millions or billions or pages.

Now you get the idea why everyone jumps up and down about backups and why it would be nice if Microsoft could ship a 100 foot tall poster in the box with SQL Server that has exactly one message on it, backup your databases. If you don't have backups and you need to recover data, there are few, if any options, and you are not going to like ANY of the options.

|||Michael Hotek,
I already exec Dbcc page and i get a lot of things which i don't understand.
So, what do you mean when you said:"Read the contents of the page and extract any data that you need". How to read and extract it? By T-SQL or something else?
About my database, I give up.So, right now,I just want to know more about SQL and the way to extract the contents of the page.
Thanks
|||Copy it from the results window and paste it into Notepad, another Query window etc. This is a 100% manual process. There are zero tools. There are no shortcuts. There is no easy way to do this. In essence you are going to manually type back in every single piece of data within the database. If you go through about 100 pages in your database and look at the results, the data is pretty self-explanatory. Since you are starting at page 1, there are going to be entire pages that you aren't going to be able to do things with such as the PFS page, GAM page, SGAM page, index pages, etc. But, there are data pages in your database and when you hit one, it will be very apparent where the data is and what it means. Other than that, it's up to you. You have to look at the results pane and you have to highlight the data and copy it back out into something else in order to stick it back into your database.|||Michael Hotek
Now, I understand what you mean, thanks. :)sql

HELP!!!! - Report parameter "Read Only"

I'm stuck with a report not being able to use the URL parameter.

I get the error:

The report parameter is read-only and cannot be modified.

I do have a prompting text for the report, and I've checked the XML and there are <PROMPT></PROMPT> tags!

Most likely, you've modified the parameter definition in Report Manager to make it read-only. If you are using SQL 2005, this can happen when you mark it in the designer as 'Internal'.|||

I just dealt with a similar problem (working in RS2000) and no matter what I tried, I couldn't get the error to go away. I tried removing the parameter and re-adding it manually. I tried removing the procedure that required the parameter, re-deploying, and then adding the procedure (and thus the parameter) back in. That still didn't work. This is what I finally did:

1) Removed the parameter from the procedure (commented out the param and any references to it in the sp)

2) Refresh the dataset (to remove the parameter). Ensured the parameter was removed from the report.

3) Re-deployed the report (without the offending parameter). It worked.

4) Went back to the sp and uncommented out the parameter and all references to it

5) Refreshed the dataset (to add the parameter back into the report).

6) Re-deployed. It worked and now accepted the parameter.

I can only surmise that RS had some former reference to the parameter that indicated it was read only, and any re-deployment that I did didn't overwrite that reference. Only by completely removing the parameter, re-deploying, and adding the parameter back in did this issue go away.

I hope this helps someone out there.

|||I got the same problem with VS2005. One time paremeter was checked as "Not Prompt user". After that I changed, deleted and recreated parameter, redeploys report to report server but recived the same error "Report parameter Read Only". Its helped a manualy chnage property of report parameter direct on report server using Report Manager( check on "Propmpt User" property of required parameter). Redeploy of report from VS don't cause changes of report properties on server.

HELP!!!! - Report parameter "Read Only"

I'm stuck with a report not being able to use the URL parameter.

I get the error:

The report parameter is read-only and cannot be modified.

I do have a prompting text for the report, and I've checked the XML and there are <PROMPT></PROMPT> tags!

Most likely, you've modified the parameter definition in Report Manager to make it read-only. If you are using SQL 2005, this can happen when you mark it in the designer as 'Internal'.|||

I just dealt with a similar problem (working in RS2000) and no matter what I tried, I couldn't get the error to go away. I tried removing the parameter and re-adding it manually. I tried removing the procedure that required the parameter, re-deploying, and then adding the procedure (and thus the parameter) back in. That still didn't work. This is what I finally did:

1) Removed the parameter from the procedure (commented out the param and any references to it in the sp)

2) Refresh the dataset (to remove the parameter). Ensured the parameter was removed from the report.

3) Re-deployed the report (without the offending parameter). It worked.

4) Went back to the sp and uncommented out the parameter and all references to it

5) Refreshed the dataset (to add the parameter back into the report).

6) Re-deployed. It worked and now accepted the parameter.

I can only surmise that RS had some former reference to the parameter that indicated it was read only, and any re-deployment that I did didn't overwrite that reference. Only by completely removing the parameter, re-deploying, and adding the parameter back in did this issue go away.

I hope this helps someone out there.

|||I got the same problem with VS2005. One time paremeter was checked as "Not Prompt user". After that I changed, deleted and recreated parameter, redeploys report to report server but recived the same error "Report parameter Read Only". Its helped a manualy chnage property of report parameter direct on report server using Report Manager( check on "Propmpt User" property of required parameter). Redeploy of report from VS don't cause changes of report properties on server.

HELP!!!! - Report parameter "Read Only"

I'm stuck with a report not being able to use the URL parameter.

I get the error:

The report parameter is read-only and cannot be modified.

I do have a prompting text for the report, and I've checked the XML and there are <PROMPT></PROMPT> tags!

Most likely, you've modified the parameter definition in Report Manager to make it read-only. If you are using SQL 2005, this can happen when you mark it in the designer as 'Internal'.|||

I just dealt with a similar problem (working in RS2000) and no matter what I tried, I couldn't get the error to go away. I tried removing the parameter and re-adding it manually. I tried removing the procedure that required the parameter, re-deploying, and then adding the procedure (and thus the parameter) back in. That still didn't work. This is what I finally did:

1) Removed the parameter from the procedure (commented out the param and any references to it in the sp)

2) Refresh the dataset (to remove the parameter). Ensured the parameter was removed from the report.

3) Re-deployed the report (without the offending parameter). It worked.

4) Went back to the sp and uncommented out the parameter and all references to it

5) Refreshed the dataset (to add the parameter back into the report).

6) Re-deployed. It worked and now accepted the parameter.

I can only surmise that RS had some former reference to the parameter that indicated it was read only, and any re-deployment that I did didn't overwrite that reference. Only by completely removing the parameter, re-deploying, and adding the parameter back in did this issue go away.

I hope this helps someone out there.

|||I got the same problem with VS2005. One time paremeter was checked as "Not Prompt user". After that I changed, deleted and recreated parameter, redeploys report to report server but recived the same error "Report parameter Read Only". Its helped a manualy chnage property of report parameter direct on report server using Report Manager( check on "Propmpt User" property of required parameter). Redeploy of report from VS don't cause changes of report properties on server.

HELP!!!! - Report parameter "Read Only"

I'm stuck with a report not being able to use the URL parameter.

I get the error:

The report parameter is read-only and cannot be modified.

I do have a prompting text for the report, and I've checked the XML and there are <PROMPT></PROMPT> tags!

Most likely, you've modified the parameter definition in Report Manager to make it read-only. If you are using SQL 2005, this can happen when you mark it in the designer as 'Internal'.|||

I just dealt with a similar problem (working in RS2000) and no matter what I tried, I couldn't get the error to go away. I tried removing the parameter and re-adding it manually. I tried removing the procedure that required the parameter, re-deploying, and then adding the procedure (and thus the parameter) back in. That still didn't work. This is what I finally did:

1) Removed the parameter from the procedure (commented out the param and any references to it in the sp)

2) Refresh the dataset (to remove the parameter). Ensured the parameter was removed from the report.

3) Re-deployed the report (without the offending parameter). It worked.

4) Went back to the sp and uncommented out the parameter and all references to it

5) Refreshed the dataset (to add the parameter back into the report).

6) Re-deployed. It worked and now accepted the parameter.

I can only surmise that RS had some former reference to the parameter that indicated it was read only, and any re-deployment that I did didn't overwrite that reference. Only by completely removing the parameter, re-deploying, and adding the parameter back in did this issue go away.

I hope this helps someone out there.

|||I got the same problem with VS2005. One time paremeter was checked as "Not Prompt user". After that I changed, deleted and recreated parameter, redeploys report to report server but recived the same error "Report parameter Read Only". Its helped a manualy chnage property of report parameter direct on report server using Report Manager( check on "Propmpt User" property of required parameter). Redeploy of report from VS don't cause changes of report properties on server.

HELP!!! Trying to schedule SSIS package

Hello everybody,

I try to schedule a SSIS package.

When I run manualy, it works without error but when I schedule it, the step fail with error: "Executed as user:... The package execution failed. The step failed."

This package contain just a SQL Task that execute a truncate table (it's for the test...)

I try all solution I found in this forum and others but all not works.

Have you an idea ?

Thanks a lot

Arnaud

Are you doing any logging? The error message will be in there.

You should also take note of this: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html

-Jamie

|||

Ok it's working now.

It's just because the connection failed and the path for the flath file must be \\<server>\<directory>\<file>

Thanks very much for your swiftness

Arnaud

sql

HELP!!! Printer Delivery Extension not Printing Landscape

Hello All,

I'm using SQL Server 2005 Reporting Services, and I'm trying to have subscriptions print. To try this, I built, installed, and configured the printer delivery extension sample provided by Microsoft.

Everything appeared to be working fine. That is, I can schedule a report to print automatically using the printer delivery extension. However, the problem is that the reports always print portrait.

We have a number of reports--some are portrait and some are landscape. So, obviously, I need the landscape reports to print lanscape.

I've even tried "hard-coding" the page width and page height parameters in the printer delivery extension to try to force it to print landscape, but it still always prints portrait.

Would any one know how to have reports that are delivered to a printer actually print in the way they are created (i.e., print landscape if the report is set up as a landscape report)?

Do I have to use the IMAGE format? Could I use PDF? If so, how?

Thanks!

Hi,

there is a likewise issue if you use linked reports in RS - the linked report does not contain the original page settings.

It probably could be that you would have to set the page settings programmatically like described by Brian Welcker for the linked reports:
http://www.fits-consulting.de/blog/PermaLink,guid,e3f1cf4a-f9d6-44d8-86e5-84a59531f87c.aspx

hth...

cheers,
Markus

|||

Thanks for the info. Markus. Unfortunately, setting the page settings programmatically didn't help. All reports and linked reports always print portrait, not landscape.

Therefore, would any one have any ideas on how to use the printer delivery extension and make scheduled reports be delivered automatically to a printer and acutally print in landscape?

Please see me original post and let me know if more info. is needed to answer my questions.

Thanks!

Help!!! launching report builder from url is adding .rdl to name when saving.

Hi,

When I launch a report using the following url, and then make changes to the report and save it, Reportbuilder is creating another report with the same name but also including the .rdl within the name itself.. therfore I now have two reports now displayed within the report manager

http://localhost/reportserver/reportbuilder/reportbuilder.application?/Report1

Can someone please help...

Hi,

this issue was resolved by applying SP2

thanks.

|||

or:

the same rdl has been uploaded directly using Report Manager and Published in Visual Studio at the same time...

Help!!! launching report builder from url is adding .rdl to name when saving.

Hi,

When I launch a report using the following url, and then make changes to the report and save it, Reportbuilder is creating another report with the same name but also including the .rdl within the name itself.. therfore I now have two reports now displayed within the report manager

http://localhost/reportserver/reportbuilder/reportbuilder.application?/Report1

Can someone please help...

Hi,

this issue was resolved by applying SP2

thanks.

|||

or:

the same rdl has been uploaded directly using Report Manager and Published in Visual Studio at the same time...

HELP!!! Creating Nested Data in Repeated Region Problem

Hi All, Would appreciate some assistance with the attached, I'm using some fairly complicated recordsets (ASP VBScript) for a property search website, I have a page where a user selects search by County this in turn takes them to a page which lists all the towns in the county and number of live properties in each, I'm using 4 recordsets for this - 3 of which list the towns (townsA2I, townsJ2R & townsS2Z) the 4th is a Property Count, examples of the recordsets are below (using townsAtoI and LiveProperties -

TownsA2I

<%
Dim TownA2I
Dim TownA2I_numRows

Set TownA2I = Server.CreateObject("ADODB.Recordset")
TownA2I.ActiveConnection = MM_recruta2_STRING
TownA2I.Source = "SELECT towncountyID, Town, County FROM dbo.easytolettowncounty WHERE Town LIKE 'A%' AND County = '" + Replace(TownA2I__MMColParam, "'", "''") + "' OR Town LIKE 'B%' AND County = '" + Replace(TownA2I__MMColParam1, "'", "''") + "' OR Town LIKE 'C%' AND County = '" + Replace(TownA2I__MMColParam2, "'", "''") + "' OR Town LIKE 'D%' AND County = '" + Replace(TownA2I__MMColParam3, "'", "''") + "' OR Town LIKE 'E%' AND County = '" + Replace(TownA2I__MMColParam4, "'", "''") + "' OR Town LIKE 'F%' AND County = '" + Replace(TownA2I__MMColParam5, "'", "''") + "' OR Town LIKE 'G%' AND County = '" + Replace(TownA2I__MMColParam6, "'", "''") + "' OR Town LIKE 'H%' AND County = '" + Replace(TownA2I__MMColParam7, "'", "''") + "' OR Town LIKE 'I%' AND County = '" + Replace(TownA2I__MMColParam8, "'", "''") + "' ORDER BY Town ASC"
TownA2I.CursorType = 0
TownA2I.CursorLocation = 2
TownA2I.LockType = 1
TownA2I.Open()

TownA2I_numRows = 0
%>

LiveProperties

<%
Dim LiveProperties
Dim LiveProperties_numRows

Sub sLivePropertyCount(vLocation)
vCount=0

Set LiveProperties = Server.CreateObject("ADODB.Recordset")
LiveProperties.ActiveConnection = MM_recruta2_STRING
LiveProperties.Source = "SELECT COUNT(PropertyID) As NumberofProperties, propertylive, propertylocation FROM dbo.easytoletproperty WHERE propertylive = 'y' AND propertylocation = " & vLocation & " GROUP BY propertylocation, propertylive"
LiveProperties.CursorType = 0
LiveProperties.CursorLocation = 2
LiveProperties.LockType = 1
LiveProperties.Open()

vCount=(LiveProperties("NumberofProperties"))
Response.write(vCount)

LiveProperties.Close()
Set LiveProperties = Nothing
end sub

LiveProperties_numRows = 0
%>

I've tried following the tutorial here http://www.webthang.co.uk/tuts/tuts_dmx/rob9/rob9.asp but when i review the page i get the following error -

"Microsoft OLE DB Provider for SQL Server error '80040e14'

Invalid column name 'Barnet'.

/PropertiesbyTown1.asp, line 338 "

Where line 338"

Where line 338 is the "LiveProperties.Open()" of the above recordset, when i try to view bindings on this recordset Dreamweaver gives me the following errors -

"Column 'dbo.easytoletproperty.propertylive' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

Column 'dbo.easytoletproperty.propertylocation' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause."

I would appreciate any assistance -

Try adding propertylocation to the GROUP BY clause as indicated by the error message.

HELP!!! Can not restore database from only back up I have

I had to transfer my database from one server to another. Both are running SQL 2000. I backed the database up and moved it to the new server however when I try to do a restore I get the following message:

The media set for database "xxx' has 2 family members but only 1 are provided. RESTORE DATABASE is terminating abnormally.

I did some searching and found a couple of posts that mentioned something about the back up including 2 files.

My problem is that the machine I backed this up from crashed when it was shut down and would not reboot so all of the data and the original database do not exist. Is there any hope of restoring this database. It is pretty critical.

Thanks,

Melissa :-)

Do "restore filelistonly from <backup_device>" to see what is in the backup device. Also, please post the "restore" command here so we can see what's going on.|||When you say "My problem is that the machine I backed this up from crashed when it was shut down and would not reboot so all of the data and the original database do not exist" - can you pull the drive that contained the original databases out of the machine and add it to the new one? (I'm assuming from your description that the database is on a DAS drive rather than a SAN)|||

I wish. The administrator who was trying to get the machine to boot determined it was beyond help and reformatted the drive and installed a new operating system on it. So all is lost.

Melissa : -(

|||

Ok here is the results from the restore filelistonly we ran:

LiveStats.XSP

C:\Program Files\Microsoft SQL Server\MSSQL\Data\LiveStats.XSP.mdf D PRIMARY 1188560896 35184372080640 LiveStats.XSP_log

C:\Program Files\Microsoft SQL Server\MSSQL\Data\LiveStats.XSP_log.LDF L NULL 13623296 35184372080640

I just did the restore from the menu.

|||Can you post the restore command you're using please?|||

I am using the restore wizard. Right clicking on the blank database (I also tried restoring without creating a blank database) Selecting Restore. Then I select From Device>>>browse to the location the back up file is>>>Restore backup set...database complete and I am not changing anything under the options tab.

Melissa :-)

|||

Please! Please! Please! tell me there is a way to restore this database. It is the only copy I have of webstats for almost 100 clients for the past year. The raw files were on the same hard drive that got wiped out.

Melissa :-)

|||

What happens when you run this (directly through a client connection, not from any wizard):

restore database LiveStats.XSP from <backupdevice>

|||Server: Msg 3132, Level 16, State 1, Line 1
The media set for database 'LiveStatsXSP' has 2 family members but only 1 are provided. All members must be provided.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.|||

Greetings.

It looks as if there is more to the backup than the one file which you are specifying.

Is there a chance that your backup produced more than one file, and that you still have access to both?

The command RESTORE LABELONLY FROM <backup_device> will tell us more about the mackup media.

|||

Here are the results from the Restore Label Only

NULL {525AA069-12A6-4E37-92CF-737C4FD9E4E2} 2 2 {F9E38D61-0000-0000-0000-000000000000} 1 0 NULL Microsoft SQL Server 4608 2006-06-30 16:42:25.000

Unfortunately that is the only file that was zipped up and moved to the new server. :-(

|||

That error tells us that when the backup was done, it was a striped backup, so the data was written to two different files in alternating stripes similar to the way a striped disk works. That means that we have to find that other file for us to have any chance of restoring the database.

The good news is that it is highly likely to be in the same location as the first backup file that you're using to restore.

The bad news is that without that other file, we cannot restore the database. Do you have ANY other copies of the backup anywhere? Even a system backup might be helpful.

|||Wow. Allowing the user to stripe across two devices is so risky. I was hoping to use a dummy striped member but it looks like you have the GUID set for each mediaset. Thus, the restore still fails. Another suggestion , make it like RAID-5. Only allow striping across 3 or more devices.|||

I had a feeling the news was not going to be good. It sounds like I am pretty much out of luck.I can not find a back up of that data anywhere.

I guess some lessons are just more painful to learn than others. If there is anything else I can try please let me know.

Melissa

sql

HELP!!! Can not restore database from only back up I have

I had to transfer my database from one server to another. Both are running SQL 2000. I backed the database up and moved it to the new server however when I try to do a restore I get the following message:

The media set for database "xxx' has 2 family members but only 1 are provided. RESTORE DATABASE is terminating abnormally.

I did some searching and found a couple of posts that mentioned something about the back up including 2 files.

My problem is that the machine I backed this up from crashed when it was shut down and would not reboot so all of the data and the original database do not exist. Is there any hope of restoring this database. It is pretty critical.

Thanks,

Melissa :-)

Do "restore filelistonly from <backup_device>" to see what is in the backup device. Also, please post the "restore" command here so we can see what's going on.|||When you say "My problem is that the machine I backed this up from crashed when it was shut down and would not reboot so all of the data and the original database do not exist" - can you pull the drive that contained the original databases out of the machine and add it to the new one? (I'm assuming from your description that the database is on a DAS drive rather than a SAN)|||

I wish. The administrator who was trying to get the machine to boot determined it was beyond help and reformatted the drive and installed a new operating system on it. So all is lost.

Melissa : -(

|||

Ok here is the results from the restore filelistonly we ran:

LiveStats.XSP

C:\Program Files\Microsoft SQL Server\MSSQL\Data\LiveStats.XSP.mdf D PRIMARY 1188560896 35184372080640 LiveStats.XSP_log

C:\Program Files\Microsoft SQL Server\MSSQL\Data\LiveStats.XSP_log.LDF L NULL 13623296 35184372080640

I just did the restore from the menu.

|||Can you post the restore command you're using please?|||

I am using the restore wizard. Right clicking on the blank database (I also tried restoring without creating a blank database) Selecting Restore. Then I select From Device>>>browse to the location the back up file is>>>Restore backup set...database complete and I am not changing anything under the options tab.

Melissa :-)

|||

Please! Please! Please! tell me there is a way to restore this database. It is the only copy I have of webstats for almost 100 clients for the past year. The raw files were on the same hard drive that got wiped out.

Melissa :-)

|||

What happens when you run this (directly through a client connection, not from any wizard):

restore database LiveStats.XSP from <backupdevice>

|||Server: Msg 3132, Level 16, State 1, Line 1
The media set for database 'LiveStatsXSP' has 2 family members but only 1 are provided. All members must be provided.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.|||

Greetings.

It looks as if there is more to the backup than the one file which you are specifying.

Is there a chance that your backup produced more than one file, and that you still have access to both?

The command RESTORE LABELONLY FROM <backup_device> will tell us more about the mackup media.

|||

Here are the results from the Restore Label Only

NULL {525AA069-12A6-4E37-92CF-737C4FD9E4E2} 2 2 {F9E38D61-0000-0000-0000-000000000000} 1 0 NULL Microsoft SQL Server 4608 2006-06-30 16:42:25.000

Unfortunately that is the only file that was zipped up and moved to the new server. :-(

|||

That error tells us that when the backup was done, it was a striped backup, so the data was written to two different files in alternating stripes similar to the way a striped disk works. That means that we have to find that other file for us to have any chance of restoring the database.

The good news is that it is highly likely to be in the same location as the first backup file that you're using to restore.

The bad news is that without that other file, we cannot restore the database. Do you have ANY other copies of the backup anywhere? Even a system backup might be helpful.

|||Wow. Allowing the user to stripe across two devices is so risky. I was hoping to use a dummy striped member but it looks like you have the GUID set for each mediaset. Thus, the restore still fails. Another suggestion , make it like RAID-5. Only allow striping across 3 or more devices.|||

I had a feeling the news was not going to be good. It sounds like I am pretty much out of luck.I can not find a back up of that data anywhere.

I guess some lessons are just more painful to learn than others. If there is anything else I can try please let me know.

Melissa