0
votes
1answer
134 views

Creating copy of schema in MS SQL server

I am relativley new to MS SQL server. I need to create a test database from exisitng test data base with same schema and get the data from production and fill the newly created empty database. For ...
3
votes
1answer
296 views

sql server limitation of data size

This question is related to my SQL Data type size A varchar(max) seems to be able to store up to 2GB. What I can not understand though is that in this link sql row overflow MS says (my emphasis): ...
0
votes
4answers
2k views

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some ...
1
vote
1answer
37 views

Why does it appears this error when I install SQL Server 2008?

It appears that "Performance counter registry hive consistency has failed". What's the cause of that error? And how can I resolve it? Thanks in advance.
1
vote
3answers
66 views

slow database insertion slowness sql server

At some costumer we have a really slow insertion to the database (three time slower then normal). I cannot see the reason why it happening. Checked the network and it seems to be ok. Any suggestions ...
4
votes
1answer
167 views

Delete Database Information

We had our production database located on a production server. The database got deleted some how but I don't know how is was deleted. How can I determine who deleted the database, what was the IP ...
1
vote
2answers
308 views

SQL Server: Filegrowth options for Data Warehouse database?

I'm creating a database for data warehousing purposes. The database will grow about 10 000 - 100 000 rows in a week (this is a guess). I think that I'll have to go with database file autogrowth, what ...
0
votes
1answer
400 views

How do I connect remotely to SQL Server from Windows client?

Having a bit of an issue connecting to SQL SERVER remotely from Windows. I've verified that all of my settings are correct via SQL SERVER MANAGEMENT STUDIO EXPRESS and SQL SERVER CONFIGURATION ...
1
vote
2answers
156 views

Are there alternatives to the “Copy Database” option on MSSQL Server Management Studio?

The reason I ask this is because it doesn't work. I haven't tried taking it offline yet because it is almost always in use. In the worst case I will attempt to take it offline and use "Copy Database" ...
0
votes
1answer
853 views

How to change schedule of backup jobs using SQL Management Studio

I have an SQL Server 2005 on our lab network, I installed MS SQL Management studio on separate computer to connect to the SQL Server to schedule a backup job of a few database. It worked fine for the ...
1
vote
1answer
67 views

Avoiding SQL Server 2005 tables with same names, but with different owners

What is the most likely cause of this behavor with SQL Server 2005? TEST #1: I run Management Studio Express, connect to my local database with "windows authentication" and see that I have 1 ...
1
vote
2answers
611 views

At which threshold does Autogrow Happen in SQL

When a SQL2005 Server's Autogrow is enabled. At which size does this operation take place? Is it triggered on Percentage / Based on statistic's / ... Is this a thing i can configure? I mean not the ...
0
votes
1answer
79 views

Do I need to recreate statistics if I had to drop them to add a foreign key

I have a database which had all it's foreign-key relationships dropped at some unknown time in the past (don't ask). I have an old copy of the database which isn't good to restore from, but the ...
0
votes
1answer
331 views

Should I partition my main table with 2 millions rows?

I am a developer and would need some DBA-advices. We are starting to get performance problem with a MSSQL2005 database. The visible effects of the incidents is mainly CPU-hog on the server but ...
2
votes
1answer
649 views

SQL Server 2008 Unique Problem for bring DB Online

This is my error I am facing TITLE: Microsoft.SqlServer.Smo Set offline failed for Database 'Go3D_Retailer ------------------------------ ADDITIONAL INFORMATION: An exception ...
1
vote
1answer
127 views

SQL 2005: Maximum number of columns per table?

In MS SQL 2005, how many columns can you create in a table before hitting the limit? I think it is 1024 columns per table but I'm not 100% sure. Just need a confirmation. Thanks!
0
votes
2answers
4k views

How to script sql server 2005 database with data?

I use sql server 2005 as my database for my web application.... I generated scripts of the database by, Database->Right Click->Tasks->Generate Scripts I can script all my Tables,Stored ...
0
votes
2answers
3k views

Import database: SQL Server 2005 Express to SQL Server 2008 Enterprise

I have two servers 1 x SQL Server 2005 Express and 1 x SQL Server 2008 Enterprise How can I move/import my database from SQL Server 2005 Express to SQL Server 2008 Enterprise? (BACKUP SQL SERVER ...
1
vote
2answers
156 views

What kind of database server should I use for a 500k stored procedure calls per day database?

I have a database that gets about 500,000 stored procedure calls a day in addition to other stuff. It's running too slow for us and we're going to upgrade it when we get around to it. I'm looking at ...
1
vote
1answer
268 views

Problem with restoring a Blackberry configuration database on Microsoft SQL Server

I am attempting to restore a Blackberry configuration database on Microsoft SQL Server 2005. The command goes like this: restore database besmgmt-test from disk = "C:\besmgmt-test.bak"; with move ...
4
votes
1answer
803 views

SQL Server Developer Edition versus SQL Server Standard

not sure I understand this but I am going to throw my assumption out there: SQL Server 2008 Standard & Enterprises editions are for running full database services on server (not just but for ...
0
votes
2answers
269 views

SQL Server Partial Backups

We currently distribute snapshots of our database to our stores by using rdiff on compressed backups of the entire database. In order to optimize how long it takes to both create these backups, and ...
0
votes
2answers
4k views

Unable to back up SQL Server databases using a maintenance plan

I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select ...
1
vote
3answers
6k views

How to restore the SQL Server model database?

Since a few days ago, when I try to start the SQL Server service, it fails with the following error logged to the NT Application Log: An error occurred during recovery, preventing the database ...
3
votes
6answers
850 views

How do I restore to a SQL backup I made two days ago?

Database disasters only happen to other people, right? RIGHT?!? I'm sure this has never happened to anyone since the beginning of computer history, but, believe it or not, I'm having a problem with a ...
4
votes
7answers
2k views

My database using sql server 2005 express is over 4GB, I have no money, am I screwed?

Any thoughts of how to solve this? I tried creating another database and putting some tables there, but actually there is just 1 big table with almost 3 million rows, this table is using all the ...
2
votes
5answers
1k views

How to install SQL Server 2000, SQL Server 2005 and SQL Server 2008 on a single machine

I'm in the process of migrating development databases from an old (soon to be decommissioned) database server to a VMWare-hosted virtual machine running Windows 2008 x64. The old server runs SQL ...
0
votes
2answers
4k views

How to connect to a local SQL Server?

how to configure SQL Server 2005 for remote connection? I have to access a local SQL Server with a web application. Thank you!
1
vote
4answers
325 views

Evaluating how much database size is needed for a content base website

I am having a hard time evaluating how much size i need for my SQL2005 database. I am creating a content based website (articles - videos - images - forums ) with user profile and was thinking about ...
2
votes
4answers
1k views

Determine Who Dropped a Database?

I have a SQL Server 2005 database that has been deleted, and I need to discover who deleted it. Is there a way of obtaining this user name? Thanks, MagicAndi.
0
votes
4answers
738 views

What is the best way to backup the schema of a sql server 2005 express database?

I want to backup the schema of a sql server 2005 database from the command line. Whats the best way to do this? Update I ended up buying SQL Compare 8.1 from Red Gate Software. It works just as ...
1
vote
5answers
678 views

Error when trying to view properties in Management Studio

I am having trouble with sql manager after install SQL 2005 SP3, Can any shed any light on this one. Thanks TITLE: Microsoft SQL Server Management Studio Cannot show requested dialog. ...
12
votes
7answers
4k views

SQL Server - Force DB in memory?

We have a beefy Windows 2008 x64 server (4 x 4 core CPU, 32GB RAM) running SQL Server 2005 64-bit. We have a small (6GB) but very important database that is somewhat slow to access until the pages are ...