error: copy database wizard

SQL SERVER SERVICE IS RUNNING UNDER THE LOCAL SYSTEM
ACCOUNT.
YOU NEED TO CHANGE YOUR SQL SERVER SERVICE ACCOUNT TO
HAVE THE RIGHTS TO COPY FILES OVER THE NETWORK.
Hi,
Yes, The copy database wizard requires the write permissions in destination
server folder. So you should start the SQL Server in both the servers using
domain user which got write access to the destination server folder.
How to change the startup SQL server account:-
1. Go to Control Panel -- Admin tools -- Services
2, Double click MSSQL server services
3. Go to Log on option and change the start up account and password to a
domain user.
4. Do the same for both servers
5. restart both sql servers.
(I feel like you are starting SQL server in Local system account.)
Thanks
Hari
MCDBA
"new" <anonymous@.discussions.microsoft.com> wrote in message
news:a8ce01c4368d$098b76c0$a401280a@.phx.gbl...
> SQL SERVER SERVICE IS RUNNING UNDER THE LOCAL SYSTEM
> ACCOUNT.
> YOU NEED TO CHANGE YOUR SQL SERVER SERVICE ACCOUNT TO
> HAVE THE RIGHTS TO COPY FILES OVER THE NETWORK.

Error: 1105, Severity: 17, State: 2

Hi ,

I have a SQL Server 2000 database on my C drive.

Over the weekend my C drive got full due to my transaction log files ballooning up.

At that point none of my users were able to log into their the VB application and enter data.

I freed up some disk space, and then the users were able to log in fine, except for a certain column variable(aggregate) values were negative.

I deattached the DBs and Ldf files and made copies of them on to a test envirnoment. Within the test environment, I ran SQL Query Analyzer with SQL statments that did give me the aggregate values as negative. This matched my VB application values aswell.

I ran

DBCC CHECKDB -- no errors

DBCC DBREINDEX -- no errors

Our programming vendor tells us the DBs are corrupt.

From Error file

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

2007-01-30 19:43:56.95 spid52 C:\Program Files\Microsoft SQL Server\MSSQL\Data\tempdb.mdf: Operating system error 112(There is not enough space on the disk.) encountered.

2007-01-30 19:43:56.98 spid52 Error: 1105, Severity: 17, State: 2

2007-01-30 19:43:56.98 spid52 Could not allocate space for object '(SYSTEM table id: -900439724)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full..

2007-02-23 09:56:21.21 spid56 C:\Program Files\Microsoft SQL Server\MSSQL\Data\ActgSQL.mdf: Operating system error 112(There is not enough space on the disk.) encountered.

2007-02-23 09:56:21.24 spid56 Error: 1105, Severity: 17, State: 2

2007-02-23 09:56:21.24 spid56 Could not allocate space for object 'POSInventory' in database 'ActgSQL' because the 'PRIMARY' filegroup is full..

2007-02-23 11:11:09.74 spid56 Error: 1105, Severity: 17, State: 2

2007-02-23 11:11:09.74 spid56 Could not allocate space for object 'POSInventory' in database 'ActgSQL' because the 'PRIMARY' filegroup is full..

2007-02-23 15:50:19.27 spid59 Process ID 53 killed by hostname ORCHID, host process ID 3360.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

I thought I had backups but I don t. So now I m in a big bind. Help!!

Any suggestions ?

No.. i don't think your database is corrupted. the only thing is that it could not have able to commit the transaction done when there was no space in the desk.. if your statement are not concluded in BEGIN TRAN / COMMIT TRAN.. some data inconsistancy may occur... As such the database may not be corrupted as a whole. This is a common problem when there is no DBA or DBA background person around. You need to keep a track of all backups which u r taking and also TL and TempDb growth etc..

Madhu

Error with restoring Backups

I recieved 4 database's that were backed up from our client. They are using SQL Server 2000 and each of the files has no extension.

When attempting to restore a database of the same name in SQL Server Express 2k5 I recieve the following error.

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided

Is there a way to restore the backup without the log backup?

Thank you
-Robert-

Hi,

i just guess that you don′t have a full backup specified here. YOu will have to pick the Full backup and apply the Diff. backups or transactional backups afterwards.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error while creating database

While trying to recreate a database i receive error 5149
database already exists.. Yet it doesn't. Have deleted
the files in the subdirectory the data and index files but
i can't see that there are any others to delete. Not sure
what else to do..Can you post the actual message text? This is important in diagnosing
possible causes if this error.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Debbie" <debbieba@.spokesman.com> wrote in message
news:0e0301c3676e$535579c0$a001280a@.phx.gbl...
> While trying to recreate a database i receive error 5149
> database already exists.. Yet it doesn't. Have deleted
> the files in the subdirectory the data and index files but
> i can't see that there are any others to delete. Not sure
> what else to do..