Monday, July 15, 2013

[SQL Server 2008 issues] Error on Restore

[SQL Server 2008 issues] Error on Restore

Error on Restore

Posted: 14 Jul 2013 06:24 PM PDT

Hi, The file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\sample.mdf' cannot be overwritten. It is being used by database 'sample'.File 'sample' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\sample.mdf'. Use WITH MOVE to identify a valid location for the file.Problems were identified while planning for the RESTORE statement. Previous messages provide details.RESTORE DATABASE is terminating abnormally.Plz.... Help..?

Restore the database into temp database

Posted: 14 Jul 2013 05:28 PM PDT

Hi,How can i restore the database into temp database in SQL server 2008 R2Advance Thanks.......,

Raid 10

Posted: 14 Jul 2013 06:15 PM PDT

Hello.The average bytes/read is between 64k and 128k and the average bytes/write is between 32k and 64k.What is the best, Raid 10 2+2 with stripe size 128k and cluster 64k or Raid 10 4+4 with stripe size 128k and cluster 32k?Thanks.

decalre select

Posted: 14 Jul 2013 05:02 PM PDT

create table kateqor(id int not null identity(1,1),Name nvarchar(50))insert into kateqor(Name)values(N'Mənzildə qurum')select*from kateqorbut when I do a query declare @kat nvarchar(50)set @kat='Mənzildə qurum'select * from kateqor where Name=N(@kat)I receive an errorPost 195, Level 15, state 10, line 4'N' is not a recognized function name.

SQL 2008 Error: 4014, Severity: 20, State: 11

Posted: 23 Feb 2010 10:46 PM PST

HiI have had a problem with our SQL server which has resulted in the error message below. I have searched Microsoft but they don't have any further information on the error. I wondered if anyone else has come across it. It is causing a problem because it caused our ISA to crash as it was unable to write to the database for more than 30 seconds! Any ideas much appreciated!Many thanks!FraggleLog Name: ApplicationSource: MSSQL$CORPORATEDate: 24/02/2010 12:20:53Event ID: 4014Task Category: ServerLevel: ErrorKeywords: ClassicUser: N/AComputer: W8-SQL3A.XXXDescription:A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 64, output error: 0)

SQL Server Error Log retention

Posted: 14 Jul 2013 02:14 PM PDT

Hi Guys,Understand that by default SQL Server has 7 error logs.The oldest error log records will be deleted each time after SQL Server restarts.I'm looking for a solution that will retain the error logs for one year. (due to some security policy)Increasing the number of error logs doesn't help much as I won't be able to determine how many times SQL Server will be restarted a year.Anyone have solution to it on how can I have a rule to only remove error logs older than one year?thanks

sp_addextendedproperty

Posted: 14 Jul 2013 05:38 PM PDT

Hi All,I came across "sp_addextendedproperty" in Adventureworks2008R2 .EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for ContactType records.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'ContactType', @level2type=N'COLUMN',@level2name=N'ContactTypeID'GO Can someone help me explaining the use of this sp..Where and when do you use it..If possible can you please explain me with someother example..

SQL Disk Error

Posted: 14 Jul 2013 05:00 PM PDT

Dear Gurus,I am getting attached error of disk when installing SECOND INSTANCE of SQL 2008 R2 please help .http://tinypic.com/view.php?pic=2nuk85z&s=5http://tinypic.com/r/14crv5u/5http://tinypic.com/r/t057jr/5Your kind help is needed.ThanksMalik Adeel Imtiaz

Restoring diff backup problem

Posted: 14 Jul 2013 09:14 AM PDT

i am trying to mirror the database,i have restored the full database backuopnow i need to restore diff back and log backup.can i please has so assistance, i am not sure how to do it.

Clustered Index Ordering & Insert Speeds

Posted: 14 Jul 2013 12:13 PM PDT

Hi,We used to have a clustered index which consisted of 5 fields, this was ordered incorrectly which meant new inserts caused a lot of bad page splits.This CI was reordered to be correct and that composite (5 fields) key would now be always ascending therefore it will not insert anything in between the pages.I confirmed that there were minimal page splits via the transaction logs. However the inserts now are taking approximately 10 times longer than before.There was an additional non-clustered index put in to cover for scenarios that the new CI doesn't cover, this is causing some new page splits, however I doubt that the non-clustered index page splits cause that much of a difference.I use SSIS OLE DB Destination with Fast Load & Check Constraints Options.Any idea what would be the issue, or what I should look at?

restoring databae to setup Mirroring

Posted: 14 Jul 2013 11:55 AM PDT

i have 123Gig of database,i am trying to setup mirroring for it.we take full backup every week and diff backup every night, and trans log every hour.and last full database backup was taken 2 days ago and we have diff backups since last full backuop.what should be the restore strategy for mirrored database.Please advise

SQL 2000 - Maintenance Plan

Posted: 14 Jul 2013 09:13 AM PDT

In SQL 2000 while creating maintenance plan, there was Optimizations which REORGANIZED the data and indexes. What it does really? Does it reorganize all the indexes in the database?

How to get the month wise row of record if transaction present or not

Posted: 14 Jul 2013 03:06 AM PDT

Hi,Is that possible to write in single query to get the below results -I need to get the month wise records from the transaction table. If records for that month is not present, then previous month set of common columns values to be created for current month (Company, Customer ID, Account No, Type) with previous month amount as opening balance and current amount as 0 and closing balance as opening balance.thanks
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog